I revisit the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.

Tip : The SQL Server Numbers Table, Explained – Part 2

Tip : The SQL Server Numbers Table, Explained – Part 1

I continue a series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.

I continue a series on upsizing an IDENTITY column from int to bigint, detailing several challenging obstacles.

A recent Visual Studio outage has been largely blamed on the cardinality estimator, but I think the query itself has a share of the blame.

I describe a few different causes for a symptom you might describe as a "runaway" query in SQL Server.