Robert Sheldon UPDATE Basics in SQL Server SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts... 21 June 2010 17 min read
Robert Sheldon SQL Server APPLY Basics One of the most interesting additions to SQL Server syntax in SQL Server 2005 was the APPLY operator. It allows... 24 May 2010 12 min read
Robert Sheldon SQL Server Common Table Expression (CTE) Basics The SQL Server common table expression was introduced into standard T-SQL to simplify queries for which a derived table just... 29 April 2010 11 min read
Paul Nielsen Switching rows and columns in SQL When they use SQL Server, one the commoner questions that Ms Access programmers ask is 'Where's the TRANSFORM/PIVOT command? So... 04 February 2010 4 min read
Robert Sheldon BCP Utility Guide: Import & Export SQL Server Data Master the SQL Server bcp command-line utility. Covers export, import, queryout, format files, authentication, and practical examples for bulk data... 10 December 2009 36 min read
Anith Sen Five Simple Database Design Errors You Should Avoid Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five... 16 October 2009 18 min read
Plamen Ratchev Ten Common SQL Programming Mistakes: NULL, NOT IN, Cursors, Scalar UDFs Ten common SQL programming mistakes that trip up developers and DBAs: NULLs and the NOT IN predicate, functions on indexed... 20 August 2009 28 min read
Pinal Dave Introduction to Change Data Capture (CDC) in SQL Server 2008 Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what... 03 August 2009 17 min read
Robert Sheldon FOR XML in SQL Server: RAW, AUTO, EXPLICIT & PATH Modes Complete guide to the FOR XML clause in SQL Server. Learn all four modes - RAW, AUTO, EXPLICIT, and PATH... 27 May 2009 36 min read
András Belokosztolszki Removing Duplicates from a Table in SQL Server Sometimes, in SQL, it is the routine operations that turn out to be the trickiest for a DBA or developer.... 11 February 2009 13 min read
Phil Factor The TSQL of Text Files Phil returns to the old subject of 'Getting text-based data in and out of SQL Server'. He shows various easy... 19 January 2009 15 min read
Robert Sheldon Understanding Full-Text Indexing in SQL Server Microsoft has quietly been improving full-text indexing in SQL Server. It is time to take a good look at what... 29 December 2008 19 min read
Robert Sheldon SQL Server Index Basics Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of... 25 November 2008 10 min read
T-SQL Programming Anith Sen in T-SQL Programming Concatenate Row Values in SQL Server: STRING_AGG and T-SQL Methods Learn how to concatenate row values in SQL Server using STRING_AGG (SQL Server 2017+), FOR XML PATH, recursive CTEs, and... 31 July 2008 17 min read
Nigel Rivett Identity Columns When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the... 12 May 2008 12 min read
Phil Factor Reading and Writing Files in SQL Server using T-SQL SQL Server provides several "standard" techniques by which to read and write to files but, just occasionally, they aren't quite... 10 April 2007 10 min read
Keith Fletcher Creating Cross Tab Queries and Pivot Tables in SQL For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored... 27 March 2007 18 min read
Database Administration Louis Davidson in Database Administration Ten Common Database Design Mistakes Spot and avoid the 10 database design mistakes that lead to performance problems, poor scalability, and maintenance headaches. Expert guidance... 26 February 2007 32 min read
Nigel Rivett BCP to CSV: Export SQL Server Data to CSV Files Export SQL Server data to CSV files using BCP and stored procedures. Covers delimiters, column headers, xp_cmdshell integration, and custom... 20 November 2006 13 min read
Hilary Cotter SQL Server Full Text Search Language Features SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient... 21 April 2006 24 min read
