Recently I got the opportunity to work on a very new feature of Persisting Sample Percentage for Statistics. Let us learn today.
SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query
I was asked a very interesting question about statistics TIME and IO for SQL Server Management Studio, let us discuss that in today’s blog post.
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
A client wanted to undo the damage from Database Engine Tuning Advisor. Here is how to drop all the hypothetical indexes of a database that DTA left behind.
How to Find Table Cardinality from the Execution Plan? – Interview Question of the Week #213
How to find table cardinality from the execution plan? I answer this health check question in two different ways, using a simple AdventureWorks query.
SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
Update statistics with FULLSCAN ran forever because MAXDOP was 2 at the database level. Here is how we managed to update table statistics in parallel.
SQL SERVER – Enabling Older Legacy Cardinality Estimation
A client’s server kept going down on RESOURCE_SEMAPHORE waits, and the quick patch that kept it up was enabling the older legacy cardinality estimation.
SQL SERVER – Say No To Database Engine Tuning Advisor
After 20 years with SQL Server, my advice is simple: say no to Database Engine Tuning Advisor. It was fine in 2000, but tuning has moved far beyond it.