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 – 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.
Restore a Database in SSMS: Step by Step
To restore a database in SSMS, right-click Databases, choose Restore Database, pick the backup file, name the destination and choose the recovery state. This post covers each page of the dialog, the tail-log error that stops overwrites, and the T-SQL for a full, differential and log restore chain.
SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video
Here is a quick way to find the SQL Server version and edition in sixty seconds, plus how to read version numbers and map them to each release.
SQL SERVER – Primary Key and NonClustered Index in Simple Words
In 2006 I wrote how Primary Key and Unique Key differ. Now I fill the gap and explain primary key and nonclustered index in simple words.