SQL Statistics Archives - Page 9 of 11 - SQL Authority with Pinal Dave

SQL SERVER – Statistics for Read-Only Database are in TempDB

November 29, 2013

Here is the question I received when I was explaining about Statistics in SQLLive360 event in Orlando. “As we use database tables and run various queries on SQL Server, it automatically creates statistics and the statistics helps eventually queries to execute efficiently. I also understand that statistics are stored in…

SQL SERVER – SQL Server Statistics Name and Index Creation

September 17, 2012

Pinal Dave

SQL Performance

SQL Error Messages, SQL Index, SQL Scripts, SQL Server, SQL Statistics

Sometimes something very small or a common error which we observe in daily life teaches us new things. SQL Server Expert Sandip (winner of Joes 2 Pros Contests) has come across similar experience. Sandip has written a guest post on an error he faced in his daily work. Sandip is working for QSI Healthcare as an Associate Technical Specialist and have more than 5 years of total experience. Let’s see SQL Server Statistics Name and Index Creation here.

SQL SERVER – Fix: Error: Msg 1904, Level 16 The statistics on table has 33 column names in statistics key list. The maximum limit for index or statistics key column list is 32

December 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Statistics

Earlier I wrote an article where I demonstrated that an index with more than 16 column is not possible. Here is the link to the article. After reading the same article I received email from user suggesting does it mean that statistics can be only created on only 16 columns.…

SQL SERVER – Find Details for Statistics of Whole Database

June 29, 2011

Pinal Dave

SQL Performance

SQL DMV, SQL Scripts, SQL Server, SQL Statistics

I was recently asked is there a single script which can provide all the necessary details about statistics for any database.

SQL SERVER – Solution – Puzzle – Statistics are not Updated but are Created Once

June 17, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Statistics

Earlier I asked puzzle why statistics are not updated. Read the complete details over here: Statistics are not Updated but are Created Once In the question I have demonstrated even though statistics should have been updated after lots of insert in the table are not updated.(Read the details SQL SERVER –…

SQL SERVER – Puzzle – Statistics are not Updated but are Created Once

June 2, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Statistics

After having excellent response to my quiz – Why SELECT * throws an error but SELECT COUNT(*) does not?I have decided to ask another puzzling question to all of you. I am running this test on SQL Server 2008 R2. Here is the quick scenario about my setup. Create Table…

SQLAuthority News – Solid Quality Journal – Importance of Statistics

March 22, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

My article on “Important of Statistics” has been published in Solid Quality Journal. Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like…