Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

-- This script returns information on each user-created statistics object, along with the DROP STATISTICS object to run if appropriate. SELECT DB_NAME() AS [Database], schema_name(T.schema_id) AS ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

-- This script generates SQL to set the AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS properties on for all databases on which it's currently off ...