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 – Deferred Name Resolution
Why can a stored procedure with a wrong table name be created, but not one with a wrong column name? Deferred Name Resolution explains it.
SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
Part 2 on SPARSE Columns in SQL Server 2008: how they are stored as one XML column, plus the main advantages and the limits you should know about.
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 – User Account – sa or sysadmin
SQL Server 2008 treats sysadmin as the modern home for the old sa account rights. Here is what changed and why sa now needs a password.
REVERSE: Keep Trailing Spaces in String Reversal
REVERSE changes character order while keeping supplied spaces. Use visible boundaries and byte counts to distinguish empty and missing inputs.
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.
SQLAuthority News – Thank You to Awarding Author SQL MVP
Thank you for all the wishes on my SQL MVP award. It belongs to every reader here. Send me your ideas and I will publish them with your name on this blog.