Copy and paste only gives you the last item you copied. This SQL in Sixty Seconds video shows how the Cycle Clipboard Ring in SSMS pastes earlier items too.
SQL SERVER – Beginning SQL 2012 – Spatial Unions and Collections
Aggregates are not just for sales totals. Much like a jigsaw puzzle, spatial unions assemble land coordinates together. Learn spatial unions and collections in SQL 2012.
SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2
An abstract from Beginning SQL 2012, Joes 2 Pros Volume 2, on aggregation functions and why GROUP BY limits your result set to aggregated data.
SQL SERVER – Beginning SQL 2012 – Why we use Code Comments – Abstract from Joes 2 Pros Volume 1
Why we use code comments: SQL Server lets you keep words in a query window off the record, so they are ignored at run time. An abstract from Joes 2 Pros.
QUERY_OPTIMIZER_HOTFIXES: Turning On Optimizer Fixes per Database
A vendor says to turn on optimizer hotfixes. Here is how I check the setting, try it on one statement, and restore it.
Finding Orphaned Data and Log Files Nobody Attached
Inventory orphaned data and log files by comparing data-folder contents with sys.master_files, then review candidates before cleanup.
SQL SERVER – T-SQL Script to Keep CPU Busy
Need to keep CPU busy for capacity planning or stress testing on a development server? I share an improved script, but never run it on production.