Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online

April 24, 2010

Blog reader Joyesh Mitra recently left a comment to one of my very old posts about SQL SERVER – 2005 Take Off Line or Detach Database, which I have written focusing on taking the database offline. However, I did not include how to bring the offline database to online in…

SQL SERVER – Update Statistics are Sampled By Default

April 23, 2010

Pinal Dave

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

SQL Index, SQL Scripts, SQL Statistics

After reading my earlier post SQL SERVER – Create Primary Key with Specific Name when Creating Table on Statistics, I have received another question by a blog reader. The question is as follows: Question: Are the statistics sampled by default? Answer: Yes. The sampling rate can be specified by the…

SQL SERVER – Create Primary Key with Specific Name when Creating Table

April 22, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

It is interesting how sometimes the documentation of simple concepts is not available online. I had received email from one of the reader where he has asked how to create Primary key with a specific name when creating the table itself. He said, he knows the method where he can…

SQL SERVER – When Are Statistics Updated – What Triggers Statistics to Update

April 21, 2010

Pinal Dave

SQL Performance

SQL Server, SQL Statistics

If you are an SQL Server Consultant/Trainer involved with Performance Tuning and Query Optimization, I am sure you have faced the following questions many times. When is statistics updated? What is the interval of Statistics update? What is the algorithm behind update statistics? These are the puzzling questions and more.

SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit

April 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL System Table

During several recent training courses, I found it very interesting that Worker Thread is not quite known to everyone despite the fact that it is a very important feature. At some point in the discussion, one of the attendees mentioned that we can double the Worker Thread if we double…

SQL SERVER – Find Most Active Database in SQL Server – DMV dm_io_virtual_file_stats

April 19, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Few days ago, I wrote about SQL SERVER – Find Current Location of Data and Log File of All the Database. There was very interesting conversation in comments by blog readers. Blog reader and SQL Expert Sreedhar has very interesting DMV presented which lists the most active database in SQL…

SQLAuthority News – Free eBook Download – Introducing Microsoft SQL Server 2008 R2

April 18, 2010

Pinal Dave

SQLAuthority News

Business Intelligence, SQL Download, SQL Server

Microsoft Press has published a FREE eBook on the most awaiting releases of SQL Server 2008 R2. The book is written by Ross Mistry and Stacia Misner. Ross is my personal friend and one of the most active book writers in SQL Server Domain. When I see his name on any book, I am sure that it will be high quality and easy to read book.