Paging in SQL Server 2005 with ROW_NUMBER: CTE vs. derived table. I compare both methods and show they give the same performance for common queries.
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice
The best way to select only the date part from a DATETIME value: my team member’s DATEADD and DATEDIFF method, and the CONVERT style 111 method I prefer.
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
Msg 9514 appears when you query an XML data type column with OPENROWSET. My workaround is to CAST the XML to VARCHAR(MAX), shown with an example.
SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Insert multiple records with one INSERT statement by combining SELECT and UNION ALL, instead of a separate INSERT for every row. SQL Server 2008 has a newer way.
SQL SERVER – Database Coding Standards and Guidelines Complete List Download
Download my SQL Server Database Coding Standards and Guidelines complete list as a PDF, the whole series in one file, made because readers asked for it.
SQL SERVER – Database Coding Standards and Guidelines Part 2
Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.
SQL SERVER – Database Coding Standards and Guidelines Part 1
Database Coding Standards and Guidelines Part 1: naming rules for tables, stored procedures, triggers, indexes, primary keys and foreign keys.