Joe Webb Using Covering Indexes to Improve Query Performance Designers of database systems will often assume that the use of a clustered index is always the best approach. However... 29 September 2008 12 min read
Robyn Page Phil Factor Database Design Workbench – Keys Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh... 19 September 2008 18 min read
Hugh Bin-Haad The Concept of Cardinal Reciprocity- A Primer Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a... 01 April 2008 12 min read
Adam Machanic Service Broker Advanced Basics Workbench SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we... 15 October 2007 34 min read
Adam Machanic Service Broker Foundations Workbench SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we... 14 August 2007 18 min read
Greg Larsen Choosing between CLR and T-SQL stored procedures: a simple benchmark In this short article, Greg Larsen performance benchmarks alternative CLR-based and T-SQL stored procedure solutions for retrieving operating system file... 24 April 2007 6 min read
Robyn Page SQL Server XML Cribsheet If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out... 29 March 2007 17 min read
Robyn Page Robyn Page’s SQL Server Cursor Workbench The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on... 24 January 2007 16 min read
Robyn Page Robyn Page’s SQL Server Data Validation Workbench Robyn Page provides essential techniques for ensuring the validity of the data being entered into your SQL Server tables.… 11 December 2006 15 min read
Greg Larsen Building my First SQL Server 2005 CLR Greg Larsen provides a step-by-step tour of the hurdles he had to jump in building and deploying his first serious... 06 December 2006 9 min read
Robyn Page Robyn Page’s SQL Server String Manipulation Workbench String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's... 19 September 2006 23 min read
Pop Rivett Pop Rivett’s SQL Server FAQ Pop Rivett dispenses pearls of SQL Server wisdom, this time tackling the setting of variables from dynamic SQL. Bah, humbug.… 18 September 2006 3 min read
Robyn Page Robyn Page’s SQL Server DATE/TIME Workbench To celebrate the seventh anniversary of Robyn Page's classic workbench, Phil brings it right up to date. What starts as... 16 August 2006 35 min read
Hilary Cotter SQL Server Full Text Search Language Features, Part 2 Extensive coverage of the query-time behaviour of SQL Server Full-text search, demonstrating how searches are expanded by the parser before... 04 July 2006 13 min read
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET training and career development Part 3 How do you keep your skills current? How will you prepare yourself for what you will be doing 5 years... 07 June 2006 11 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
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET Training and Career Development (part 2) In Part I of this series, I discussed the role and value of conferences in the career development of SQL... 22 March 2006 15 min read
Learn SQL Server Douglas Reilly in Learn SQL Server SQL Server and .NET Training and Career Development A number of years ago, I wrote a blog entry entitled "Who is Responsible for your Career?". It was perhaps... 24 February 2006 15 min read
