The VALUES clause does much more since SQL Server 2008. Here is a Query Plan Analysis of PIVOT and UNPIVOT queries using the profiler in dbForge Studio.
SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
Worried about your database while on vacation? John Sterrett shows how Policy Based Management helps a proactive DBA catch unwanted changes.
Comparing Two Database Schemas With T-SQL
Comparing two database schemas with catalog queries exposes missing objects, changed columns, and index differences before deployment.
Checking Data Type Mapping After a Database Migration
Audit data type mapping after migration, compare counts and checksum screens, inspect length and precision, and reconcile changed values.
SQL SERVER – How to Validate Syntax and Not Execute Statement – An Unexplored Debugging Tip
Want to validate syntax without running a query? I explain the little known SET NOEXEC setting that checks your T-SQL but does not execute it.
SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.
Nested Loops Join: When It Is the Right Choice
Loops in a plan are not always the villain. Count the inner executions and the reads before you force another join type.
SQL SERVER – Check for Database Integrity – Notes from the Field #011
In this Notes from the Field episode, Tim explains why you should check database integrity often, so corruption is caught before it is too late.
Finding What Depends on a Table
Finding What depends on a table starts with sys.dm_sql_referencing_entities, then checks cross-database code and dynamic SQL.










