Inspect row goals from TOP and EXISTS, read EstimateRowsWithoutRowGoal, and compare a targeted optimizer hint using actual plans.
SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial
A quick tutorial for Best Practices Analyzer: pick the product, start the scan, choose features, then read and export the results for your instances.
SQL SERVER – Outer Join Not Allowed in Indexed Views
Why is OUTER JOIN not allowed in indexed views? A reader was confused by the white paper answer, so I explain it with an example and ask for yours.
A Monthly Health Check You Can Run in Ten Minutes
Run a SQL Server health check that reviews backups, integrity-check evidence, file growth, users, build level, and space without guessing health.
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.
SQL SERVER – Difference Between DATETIME and DATETIME2
A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.
SQL SERVER – Fastest Way to Restore Database
A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.