This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Error message dialog for SQL Server.

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

May 30, 2015
Pinal Dave
SQL Tips and Tricks
SPARSE Columns, SQL Error Messages, SQL Scripts

A reader got Msg 511 when adding a sparse column. Sparse columns reduce the maximum row size from 8060 to 8018 bytes. Here is what that means for you.

Read More
Sql server error.

SQL SERVER – CREATE TABLE Failed Because Column ‘C1024’ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns

May 25, 2015
Pinal Dave
SQL Tips and Tricks
SPARSE Columns

Sparse columns should let a table go past 1024 columns, yet a reader’s CREATE TABLE failed saying it exceeds the maximum of 1024 columns. Here is why.

Read More
Bar chart of data pages used by 100,000 coupons at seven shares of NULL values. The plain table always uses 285 pages. The sparse table uses 433 pages at 0 percent NULL and 188 pages at 99 percent NULL

Space Used by Sparse Data: How SPARSE Columns Save Bytes

August 17, 2011
Pinal Dave
SQL Tips and Tricks
SPARSE Columns, SQL Data Storage, SQL NULL, SQL Scripts

Space used by sparse data depends on how many values are NULL. This post loads 100,000 coupons into a normal table and a SPARSE table, measures the row size and the pages, and finds the point where SPARSE stops paying off. It also shows that a NULL in a sparse column costs nothing, and that a value costs more than usual.

Read More
SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2

SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

July 14, 2008
Pinal Dave
SQL Performance
SPARSE Columns, SQL Data Storage

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.

Read More
SQL Server Unspaced Table.

SQL SERVER – 2008 – Introduction to SPARSE Columns

July 10, 2008
Pinal Dave
SQL Performance
SPARSE Columns, SQL Data Storage, SQL Scripts

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.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com