Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.
SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?
CTAS stands for Create Table As Select. In SQL Server you do it with SELECT INTO, which creates the new table and fills it with data in one step.
SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New
Executing stored procedure with result sets works for multiple resultsets too. WITH RESULT SETS handles them easily, while the old temp table method cannot.
SQL SERVER – 2012 – Executing Stored Procedure with Result Sets
Denali lets you execute a stored procedure with result sets and rename its columns at run time, with no temp table needed. Here is a quick script.
XQuery Node Identity: Equal Text Can Be Different Nodes
XQuery node identity compares source nodes, not their text. Use is beside text equality to distinguish repeated values from the same node.
Finding the Slowest Stored Procedures With sys.dm_exec_procedure_stats
Find the slowest stored procedures with cache statistics, compare CPU and reads, and use two snapshots to isolate one busy hour.
SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone
My 1700th blog post is a milestone with over 25 million views. I look back at 2011 so far, from my wait types series to my SQL Server Quiz question.