Grant Fritchey SQL Server Execution Plans – eBook Download Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have... 07 October 2009 1 min read
Robert Sheldon Using Information Schema Views Many seasoned database developers tuck away all the commonly-used INFORMATION_SCHEMA queries as templates. They're an indispensable supplement to sp_help and... 01 October 2009 13 min read
Fabiano Amorim The Query Optimizer: Date Correlation Optimisation In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to... 01 October 2009 10 min read
Michael Sorens A Unified Approach to Multi-DataBase Query Templates While trying to get the information he needed out of various SQL, MySQL and Oracle environments, Michael finally got tired... 30 September 2009 22 min read
Rodney Landrum Finding Data Corruption In this article, taken from Chapter 8 of his new book, SQL Server Tacklebox, Rodney describes how a working DBA... 29 September 2009 29 min read
Joe Celko Celko’s SQL Stumper: The Data Warehouse Problem Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems... 25 September 2009 5 min read
Simon Galbraith Downloading Software: the SQL Prompt 4 Experiment What is the best way for a Software vendor to get people to try out their tools? Is dialogue with... 18 September 2009 5 min read
Joe Celko Causation, Correlation and Crackpots Joe Celko explores the dangers of muddling correlation and causation, emphasises the importance of determining how likely it is that... 15 September 2009 13 min read
Brad McGehee A Code of Conduct for DBAs Despite the fact DBAs are protectors of an organization's knowledge, and privy to much confidential information, there is no clearly... 03 September 2009 14 min read
Hugo Shebbeare Disaster Recovery for SQL Server Databases High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This... 28 August 2009 27 min read
Timothy Wiseman Python for the SQL Server DBA Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find... 27 August 2009 8 min read
Robert Sheldon Transact-SQL Formatting Standards (Coding Styles) How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How... 25 August 2009 25 min read
Joe Celko Getting rid of SQL Code Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem... 20 August 2009 13 min read
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
Rodney Landrum SQL Server Tacklebox Free eBook As a DBA, how well-prepared are you to tackle issues such as backup failure due to lack of disk space,... 04 August 2009 3 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
Shawn McGehee SQL Backup 6: Wind of Change One could be forgiven for thinking that there is little more you can do with any third-party Backup software than... 03 August 2009 15 min read
Jacob Sebastian An Introduction to SQL Server FileStream Filestream allows us to store and manage unstructured datain SQL Server more easily. Initially, the accounts of FILESTREAM assumed prodigious... 03 August 2009 19 min read
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
