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 ...

-- 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 ...

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 ...