PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read MoreCategory: DMVs
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
Finding Deprecated Command Usage via Traces and Extended Events
Below is my posting on dealing with upgrading your SQL Server to either 2012 or 2014 and having to deal with databases that…
Read More
Finding the root cause for the tempDB log file out of space error
Here is what to do when the tempDB log file runs out of space. You will not be able to run any sp_Who*…
Read More
SQL Server 2012 DMV’s (Dynamic Management Views)
Notes about DMV’s in General DMV data is discarded when the SQL Server service is restarted as it is stored in memory and…
Read More