Seth Delconte Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012 Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1... 25 January 2013 14 min read
Grant Fritchey Statistics in SQL Server SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or... 08 January 2013 10 min read
Joe Celko SQL VIEW Basics SQL Views are essential for the database developer. However, it is common to see them misused, or neglected. Joe Celko... 10 May 2012 19 min read
SQL Server Fabiano Amorim in SQL Server SQL Server Window Function Performance: Execution Plans for Running Aggregates, LEAD, LAG, FIRST_VALUE, LAST_VALUE Performance analysis of SQL Server window functions - comparing execution plans for running aggregations (OVER + ORDER BY), LEAD and... 04 January 2012 12 min read
Robert Sheldon Incorporating XML into your Database Objects XML data can become a full participant in a SQL Server Database, and can be used in views, functions, check... 04 January 2012 14 min read
Robert Sheldon SQL Server XML Methods: query(), value(), exist(), nodes(), modify() The five SQL Server XML methods - query(), value(), exist(), nodes(), and modify() - explained with working AdventureWorks examples. Covers... 08 December 2011 23 min read
SQL Server Fabiano Amorim in SQL Server Window Functions in SQL Server: Part 2-The Frame Fabiano continues his introduction to SQL Server's implementation of the window functions by giving a history of what got implemented... 24 November 2011 13 min read
Robert Sheldon Working with the XML Data Type in SQL Server The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful... 07 November 2011 16 min read
SQL Server Fabiano Amorim in SQL Server Window Functions in SQL Server When SQL Server introduced Window Functions in SQL Server 2005, it was done in a rather tentative way, with only... 27 October 2011 12 min read
Learn SQL Server Roy Ernest in Learn SQL Server Resource Governor If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you... 26 October 2011 23 min read
Learn SQL Server Robert Young in Learn SQL Server Going Beyond the Relational Model with Data SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw... 27 September 2011 28 min read
Learn SQL Server Chris Shaw in Learn SQL Server Building Your DBA Skillset As a DBA and hiring manager, Chris Shaw has been on those sides of the recruitement process. As an MVP... 06 July 2011 23 min read
Robert Sheldon Subqueries in SQL Server Subqueries and derived tables can add great versatility to SQL statements, cut down complexity, but can occasionally be a curse... 26 May 2011 16 min read
Fabiano Amorim ShowPlan Operator of the Week – Split, Sort, Collapse 'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano after his epic series of articles about... 11 April 2011 19 min read
Joe Celko Check your Digits The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can... 07 April 2011 11 min read
Phil Factor Import HTML Data into SQL Server with PowerShell: HTML Agility Pack and DataTable Approach Scrape HTML tables, lists, and unstructured content into SQL Server using PowerShell and the HTML Agility Pack (HAP). Covers reading... 30 March 2011 22 min read
Timothy Wiseman SQL Injection: Defense in Depth So much has been written about SQL Injection, yet such attacks continue to succeed, even against security consultants' websites. The... 17 March 2011 11 min read
Paul White Understanding and Using Parallelism in SQL Server SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and... 03 March 2011 22 min read
Grant Fritchey Change Management and Source Control So, given the many good reasons for using Version Control systems for managing the changes in database applications, how does... 03 March 2011 47 min read
Robert Sheldon SQL Server BULK INSERT and OPENROWSET BULK: Performance Tuning Bulk Loads Load large datasets into SQL Server using BULK INSERT and INSERT...SELECT with OPENROWSET(BULK). Covers the core syntax, performance tuning through... 31 January 2011 21 min read
