A quick introduction to SPARSE Columns in SQL Server 2008, which take almost no space for NULL and zero values. Learn the basics and the 100,000 column limit.
SQL SERVER – 2008 – Introduction to Row Compression
Row Compression in SQL Server 2008 stores zero and null values without using disk space. Check the savings first with sp_estimate_data_compression_savings.
Trigger Overhead: Measuring the Hidden Cost of DML Triggers
Measure trigger overhead with controlled inserts, execution plans, and cached trigger statistics before moving slow work into a queue.
SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
SQL Server 2008 lets you insert multiple records using one INSERT statement with a row constructor. I compare it with separate INSERTs and the UNION ALL method.
SQL SERVER – 2008 – High Availability – Hot Add Memory
Hot Add Memory in SQL Server 2008 needs capable hardware, Enterprise or Datacenter Windows, and 64-bit Enterprise Edition or 32-bit with AWE enabled.
SQL SERVER – 2008 – High Availability – Hot Add CPU
Hot Add CPU in SQL Server 2008 is a cool high availability feature, but it needs supporting hardware and 64-bit Windows Server 2008 Enterprise or Datacenter.
SQL SERVER – 2008 – Inline Variable Assignment
SQL Server 2008 adds inline variable assignment, so DECLARE @MyVar INT = 5 works in one line. I compare it with the SQL Server 2005 way of DECLARE then SET.