“How many DMV and DVF are there in SQL Server 2008?” – this question was asked to me in one of the recent SQL Server Training.
SQL SERVER – Finding Expensive Cached Query Statements with DMVs
Finding the Most Expensive Queries starts with choosing a resource measure. I use cached statistics as an investigation aid.
SQL SERVER – Spatial Database Queries – What About BLOB
Spatial database queries are my favorite subject since TechEd India 2010. Here are the scripts to build the environment, plus a question: what about BLOB?
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size
Laerte Junior fixed my Powershell setup remotely in minutes and sent solution 3 to my puzzle on the size of each index. Here is his Powershell Index Size answer.
Finding the First Monday of Every Month in T-SQL
Calculate the first Monday without DATEFIRST, list a full year, find nth and last weekdays, and reuse the rules in an inline table function.
Where Reference Data Should Live
Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.