T-SQL Programming Joe Celko in T-SQL Programming Predicates With Subqueries The ALL, SOME and ANY predicates aren't much used in SQL Server, but they are there. You can use the... 25 August 2016 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the Second When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is... 10 August 2016 15 min read
T-SQL Programming Joe Celko in T-SQL Programming Formatting SQL Code – Part the First With the formatting of code, we sometimes do things because they've always been done that way, rather than making code... 22 July 2016 16 min read
Joe Celko Looking at VIEWs, Close Up Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how... 10 May 2016 23 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as... 31 March 2016 22 min read
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need... 09 March 2016 21 min read
Uwe Ricken When AUTO_UPDATE_STATISTICS Doesn’t Happen When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the... 07 March 2016 10 min read
Other Phil Factor in Other The Luhn Algorithm in SQL The Luhn test is used by most credit card companies to check the basic validity of a credit card number.... 16 February 2016 7 min read
Joe Celko SQL GROUP BY Basics It sometimes pays to go back and look at what you think you already know about SQL. Joe Celko gives... 08 February 2016 15 min read
Joe Celko Declarative SQL: Using CHECK() & DEFAULT SQL is unusual is that data is not passively stored. Instead you use declarative SQL to specify the rules that... 13 January 2016 13 min read
Joe Celko Declarative SQL: Using References There are several ingenious ways of using SQL References to enforce integrity declaratively. Declarative Referential Integrity (DRI) is more effective... 15 December 2015 13 min read
Joe Celko Declarative SQL: Using UNIQUE Constraints In SQL, you can express the logic of what you want to accomplish without spelling out the details of how... 04 December 2015 14 min read
Grant Fritchey Using SQL Prompt to Accelerate the Top 10 Most Common Database Scripts There may be some people who enjoy repetitive typing, but Grant Fritchey doesn't. He's always preferred SQL Prompt. The standard... 04 November 2015 8 min read
William Brewer Questions About CUBE, ROLLUP and GROUPING SETs That You Were Too Shy to Ask There are few parts of SQL Syntax as familiar as the GROUP BY clause of the SELECT statement. On the... 03 November 2015 17 min read
Grant Fritchey Top 10 Most Common Database Scripts What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant... 15 October 2015 14 min read
Phil Factor SQL Server Dependencies: Find & Track Object References Find and track object dependencies in SQL Server using SSMS, DMVs, and PowerShell. Covers soft vs hard dependencies, sys.sql_expression_dependencies, and... 24 September 2015 21 min read
Uwe Ricken How Forwarded Records are Read and Processed in a SQL Server Heap Before you deliberately use a heap in SQL Server rather than a table, it is worth understanding why a heap... 09 September 2015 16 min read
Gail Shaw How to Confuse the SQL Server Query Optimizer Gail Shaw examines three common forms of generic SQL that can and will confuse the SQL Server Optimizer to the... 09 September 2015 35 min read
Robert Sheldon How to Get NULLs Horribly Wrong in SQL Server NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to... 25 June 2015 36 min read
Alex Kuznetsov Reusing T-SQL Code Database programmers are often caught in the paradox of wanting to implement business rules and complex functionality in one place... 28 May 2015 27 min read
