Plamen Ratchev Ten Common SQL Programming Mistakes It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries. In this article, Plamen... 20 August 2009 28 min read
Joe Celko Celko’s Summer SQL Stumpers: Prime Numbers Joe Celko kicks off our series of Summer SQL Stumpers with a challenge to improve on his solution to calculating the... 23 July 2009 6 min read
Joe Celko Avoiding the EAV of Destruction A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a... 18 June 2009 11 min read
Robert Sheldon XML Data Modification Language Workbench XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases,... 28 April 2009 21 min read
Phil Factor CLR Assembly RegEx Functions for SQL Server by Example Phil Factor presents a simple CLR Assembly to allow SQL Server users to access all the powerful RegEx library methods... 15 April 2009 15 min read
Joe Celko Median Workbench SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median,... 05 April 2009 15 min read
Alex Kuznetsov Brain Teaser for Pi Day Alex has come up with a great idea for Pi Day. We should celebrate by trying to come up with... 02 March 2009 2 min read
Joe Celko Divided We Stand: The SQL of Relational Division Businesses often require reports that require more than the classic set operators. Surprisingly, a business requirement can often be expressed... 17 February 2009 17 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
Joe Celko Temporal Data Techniques in SQL In the first part of this series on Temporal Data, Joe explained how it is that the Common Era calendar... 18 January 2009 12 min read
Joe Celko Temporal Datatypes in SQL Server In the first of a series of articles on the tricks of tackling temporal data in SQL, Joe Celko discusses... 16 December 2008 10 min read
Joe Celko Unique Experiences! You'd have thought that a unique constraint was an easy concept - Not a bit of it; it can cause... 18 November 2008 14 min read
Phil Factor Robyn Page SQL Server Matrix Workbench In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in... 15 November 2008 13 min read
Joe Celko Constraint Yourself! In his first article for Simple-Talk, Joe Celko demystifies the use of Constraints, and points out that they are an... 26 October 2008 13 min read
Alex Kozak The Bejeweled Puzzle in SQL Alex Kozak provides another SQL puzzle to hone your SQL Skills with. … 09 October 2008 6 min read
Anith Sen Faking Arrays in Transact SQL It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL.... 16 September 2008 20 min read
Anith Sen Concatenating Row Values in Transact-SQL It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate. How... 31 July 2008 17 min read
William Brewer JSON and other data serialization languages The easiest way to speed up an Ajax application is to take out the 'X' and use JSON rather than... 18 July 2008 9 min read
Alex Kozak Missing Date Ranges- the Sequel Alex Kozak returns with another Date puzzle. A readers question gives Alex the inspiration to see if is possible to... 16 June 2008 7 min read
