What is a spatial database? A short definition, plus my TechEd India session on developing with SQL Server spatial data and spatial indexing.
SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005
A visual walk through to configure Management Data Collection in a few quick steps and get default reports on CPU, memory and disk for your server.
Correlated Columns and Multi-Column Statistics in SQL Server
Investigate multi-column statistics with correlated city and state values, density vectors, and plans before expecting better estimates.
What Is Locking and Blocking in SQL Server?
Locking and blocking are not the same thing, and the difference is the whole subject. I blocked a session on purpose and read it from the DMVs. Why short blocking is healthy, and why NOLOCK fixes nothing.
SQL SERVER – Introduction to Extended Events – Finding Long Running Queries
After reading Jonathan Kehayias on Extended Events, I added them to my performance tuning course. An introduction, with a way to find long running queries.
SQL SERVER – Generate Report for Index Physical Statistics – SSMS
SSMS has a standard report for Index Physical Statistics at the database level. Right click the database, open Reports, and see index details at a glance.
SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
SSMS 2008 has built-in activity and Performance Reports most people never open. Right click the server, go to Reports, Standard Reports, and pick one.