The sp_autostats procedure shows and changes the automatic statistics update setting of one table, one index or one statistic. This post turns the setting off for a table, flips it back for one index, undoes it, and shows that the database level setting and the statistics themselves are untouched.
SQL SERVER – 3 Different Ways to Set MAXDOP
There are 3 different MAXDOP scopes: instance, database and statement. Readers of my 16-versus-1 demonstration asked where to configure it.
SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
SQL SERVER – PREEMPTIVE Waits and Scheduler Context
Preemptive waits can measure work outside SQL Server cooperative scheduling. A customer asked about their increase during a health check.
Multiple OPTIMIZE FOR Hints in One Query: Value or UNKNOWN
Multiple OPTIMIZE FOR hints in one query are written as one list: each parameter gets its own value or UNKNOWN. This post compiles the same query six ways, reads the compile values and estimated rows from the plan cache, and shows which combinations SQL Server accepts.
SQL SERVER – DISTINCT Does Not Guarantee ORDER BY
DISTINCT removes duplicate result rows without guaranteeing their order. My original claim that it always sorts output was incorrect.
SQL SERVER – TOP and DISTINCT – Epic Confusion – SQL in Sixty Seconds #141
DBAs from the client’s organization ended up an argument about how T-SQL works. The discussion was about the epic confusion about TOP and DISTINCT.