Fabiano Amorim Showplan Operator of the Week – Row Count Spool The Row Count Spool operator is a simple component in an execution plan that can make an enormous difference to... 06 July 2010 5 min read
Fabiano Amorim Operator of the Week – Index Spool If you've ever wondered what happens to your queries if you're not conscientious about creating indexes, then Fabiano Amorim has... 25 June 2010 14 min read
Jonathan Lewis Oracle to SQL Server, Crossing the Great Divide, Part 3 We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis... 23 June 2010 15 min read
Robert Sheldon UPDATE Basics in SQL Server SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts... 21 June 2010 17 min read
Hima Bindu Vejella Book Review: The Art of XSD – SQL Server XML schemas The 14 chapters of "The Art of XSD", written by MVP Jacob Sebastian, will take the reader step-by-step all the... 10 June 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – Lazy Spool Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator... 10 June 2010 9 min read
Jonathan Lewis Oracle to SQL Server: Crossing the Great Divide, Part 2 A well-known Oracle expert records faithfully his struggles with the unfamiliar : SQL Server. He now sets himself the task... 26 May 2010 19 min read
Fabiano Amorim Operator of the Week – Spools, Eager Spool For the fifth part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser, he... 20 May 2010 12 min read
Fabiano Amorim Showplan Operator of the Week – BookMark/Key Lookup Fabiano continues in his mission to describe the major Showplan Operators used by SQL Server's Query Optimiser. This week he... 07 May 2010 7 min read
Jonathan Lewis Oracle to SQL Server: Crossing the Great Divide, Part 1 When a SQL expert moves from Oracle to SQL Server, he can spot obvious strengths and weaknesses in the product... 28 April 2010 23 min read
Fabiano Amorim Showplan Operator of the Week – Compute Scalar The third part of Fabiano's mission to describe the major Showplan Operators used by SQL Server's Query Optimiser continues with... 28 April 2010 6 min read
Fabiano Amorim Showplan Operator of the Week – Concatenation Fabiano continues in his mission to describe, one week at a time, all the major Showplan Operators used by SQL... 22 April 2010 3 min read
Fabiano Amorim Showplan Operator of the week – Assert As part of his mission to explain the Query Optimiser in practical terms, Fabiano attempts the feat of describing, one... 14 April 2010 7 min read
Robert Sheldon Managing Transaction Logs in SQL Server The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed... 12 November 2009 17 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
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 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
