SQL Statistics Archives - Page 8 of 10 - SQL Authority with Pinal Dave

SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent

December 4, 2013

This is a follow up blog post to my earlier blog posts about statistics for Read-Only Database. Please read the following blog post in this series to get further idea about this subject: SQL SERVER – Statistics for Read-Only Database are in TempDB SQL SERVER – How to Script Statistics…

SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only

December 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

Earlier last week I wrote a blog post about Statistics for Read-Only Database are in TempDB, I received a very interesting comment from Ayman El-Ghazali on the same blog post. Let me reproduce the same comment over here. “Nice post. What if you create a database, create some statistics in…

SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS

November 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Statistics

Here is a very interesting question, I have received after reading yesterday’s blog post SQL SERVER – Statistics for Read-Only Database are in TempDB. “Pinal, I like your blog post. I recently tried to create statistics with the help of SSMS but I was not successful. Everytime when I go to…

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

November 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

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 – DMV – T-SQL Script

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. This question made me write following script. I was initially planning to use sp_helpstats command, but I remembered that this is marked to be deprecated in future.