Performance Surprises and Assumptions : SET NOCOUNT ON
I revisit the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.
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.