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
SQL SERVER - Readers Contribution to Site - Simple Example of Cursor

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008
Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts

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.

Read More
SQL SERVER - Deferred Name Resolution

SQL SERVER – Deferred Name Resolution

July 15, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

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.

Read More
An open conservatory control cabinet reveals plain brass valves and carefully routed pipes.

SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings

July 13, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

The global configuration list shows configured and effective SQL Server settings. I compare both before deciding that a change has taken effect.

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
SQL SERVER - 2008 - Two Convenient Features Inline Assignment - Inline Operations

SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations

July 9, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility

Two convenient SQL Server 2008 features: inline assignment with DECLARE @idx INT = 0, and inline operations like SET @idx += 1. Fewer lines than before.

Read More
SQL SERVER - Find Space Used For Any Particular Table

SQL SERVER – Find Space Used For Any Particular Table

July 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Server, SQL Stored Procedure

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.

Read More
SQL SERVER - 2008 - Introduction to Row Compression

SQL SERVER – 2008 – Introduction to Row Compression

July 6, 2008
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Data Storage, SQL Scripts

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.

Read More
Previous 1 … 307 308 309 310 311 312 313 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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