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 or none of them are.... 12 November 2009 17 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 Books-on-Line. We challenged Bob Sheldon... 27 May 2009 36 min read