Explain the difference between DISTINCT and GROUP BY with a self-contained demo, HAVING filters, and a correlated-subquery plan comparison.
SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080
In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.
SQL SERVER – PowerShell Script – When Was SQL Server Last Restarted?
A simple PowerShell script that reads the ErrorLog to answer a common question: when was SQL Server last restarted? Tips to improve it are welcome.
SQL SERVER – Identify Page Splits Using Extended Events in SQL Server
How can you track page splits inside SQL Server? PerfMon gives you a count, but here is how to see each of the page splits using Extended Events.
SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)
An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.
Interview Question of the Week #019 – How to Reset Identity of Table
Reset identity values with DBCC CHECKIDENT, distinguish DELETE from TRUNCATE, and prove that identity alone does not prevent duplicates.
SQL SERVER – Script: Current IO Related Waits on SQL Server
A friend’s SQL Server in an Azure VM slowed down suddenly. Here is my handy script using sys.dm_io_pending_io_requests to see current IO related waits.










