Compare ROWS vs RANGE for running totals, handle tied sort values, write explicit frames, and check worktable reads on your server.
XML sql:column: Compare XML With a Relational Value
XML sql:column passes a typed relational value into XQuery. Keep node existence separate from a missing document and a scalar Boolean.
SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012
How fast are result sets in SQL Server 2012 compared with a temp table? I ran both methods and compared their execution plans to answer a reader.
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
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.
SQL SERVER – How to ALTER CONSTRAINT
Can you ALTER CONSTRAINT in SQL Server? No. The only way to change a constraint is to drop it and create it again, and here is the script for that.







