A reader wanted to join values from several rows into one record. Imran Mohammed answered with a simple example of cursor code in SQL Server 2005.
SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.
SQL SERVER – 2008 – Introduction to SPARSE Columns
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 – Two Convenient Features Inline Assignment – Inline Operations
Two convenient SQL Server 2008 features: inline assignment with DECLARE @idx INT = 0, and inline operations like SET @idx += 1. Fewer lines than before.
SQL SERVER – Find Space Used For Any Particular Table
Running out of drive space is a common reason SQL Server stops. sp_spaceused shows the Space Used by any table, with its row count and index size.
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.







