External Article

SQL Server 2008 Sparse Columns Identifying Columns For Conversion

SQL Server 2008 has introduced a new way to store data for columns that contain excessive NULL values called Sparse Columns. What this means is that when you declare a column as Sparse and any time a NULL value is entered in the column it will not use any space. Is there a way to identify what columns would make a good candidate for this without having to analyze each column individually?

Technical Article

SQLSaturday #10 - Tampa 2009

Looking for free SQL Server training?
Join over 250 SQL Server professionals in Tampa on January 24th, 2009 for SQL Saturday #10. Featuring 6 tracks and more than 36 SQL Server presentations, it's the biggest and best free SQL event available. Visit www.sqlsaturday.com to see event details and to register.

Blogs

5 Starter Projects for Your AI and Data Engineering Portfolio

By

Reading tutorials is fine. Shipping something is better. If you are trying to break...

The Book of Redgate: Taking Breaks

By

We work hard at Redgate, though with a good work-life balance. One interesting observation...

Database AI Agents: The Read-Only Rule

By

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Read the latest Blogs

Forums

Liability for AI Errors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Liability for AI Errors

Running a Parameter-Sensitive Stored Procedure on a Secondary Replica

By abdalah.mehdoini

Hello , I would like to run a stored procedure on a secondary replica...

Pro SQL Server Internals

By Site Owners

Comments posted to this topic are about the item Pro SQL Server Internals

Visit the forum

Question of the Day

Running SQLCMD II

I run this command to start SQLCMD:

sqlcmd -S localhost -E -c "proceed"
At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version
2> go
What happens?

See possible answers