Robert Sheldon Defragmenting Indexes in SQL Server 2005 and 2008 Rob Sheldon tackles the subject of Index Defragmentation in SQL Server 2005 and 2008, using the sys.dm_db_index_physical_stats system function. He... 31 July 2009 15 min read
Rodney Landrum The DBA as Detective: Troubleshooting Locking and Blocking In this article, taken from Chapter 5 of his great new book, SQL Server Tacklebox, Rodney describes in his own... 31 July 2009 24 min read
Roger Hart Continuous Integration with SQL Toolbelt Sometimes, you wish you had a tool to run a software development process exactly the way you need it to... 23 July 2009 17 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
Bob Cramblitt William Durkin, Serial Red Gate Beta Tester An interview with William Durkin. When he has the time, William finds it useful to work as a pre-release software... 09 July 2009 4 min read
Brad McGehee Do Not Forget to Maintain Your Indexes Index Maintenance Plans are essential for the well-being of a database. However, there is more to the process than just... 09 July 2009 15 min read
Robert Sheldon Working with Precedence Constraints in SQL Server Integration Services In SSIS, tasks are linked by precedence constraints. A task will only execute if the condition that is set by... 07 July 2009 11 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
Brad McGehee Brad’s Sure Guide to Indexes In order to best appreciate the reasons for, or importance of, the various administrative tasks that are needed for indexes,... 11 June 2009 40 min read
Barry King Reporting Services with Style Even when Microsoft neglect a feature, there are always pioneers who find ways of getting around the problem. Such is... 28 May 2009 10 min read
Robert Sheldon Using the FOR XML Clause to Return Query Results as XML The FOR XML clause in SQL Server causes a lot of difficulty, mainly because it is rather poorly explained in... 27 May 2009 36 min read
Jacob Sebastian Introduction to XML Schema What is an XML Schema, and why is it important? How did XSD develop from its precursors, DTD and XDR?... 07 May 2009 14 min read
Joe Celko SQL and the Snare of Three-Valued Logic The whole subject of the Three-Valued (also known as ternary, trivalent or 3VL) Logic of SQL tends to trip people... 07 May 2009 13 min read
Anith Sen Facts and Fallacies about First Normal Form When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith... 07 May 2009 15 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
Chris Massey Free eBook: SQL Server Crib-Sheet Compendium For everything you need to know, rather than want to know, about SQL Server Reporting Services, replication, backup, XML, performance,... 24 April 2009 1 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
Gail Shaw Finding the causes of poor performance in SQL Server, Part 2 In the first part of this series of articles, Gail showed how to find the procedures that contributed most to... 03 April 2009 28 min read
Robert Sheldon Working with Property Expressions in SQL Server Integration Services Property Expressions in SSIS packages are assigned to a property at run time. This allows parameters to be passed to... 16 March 2009 12 min read
