SQL Performance Archives - Page 61 of 100 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28

February 1, 2011

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

I have been working a lot on Wait Stats and Wait Types recently. Last Year, I requested blog readers to send me their respective server’s wait stats. I appreciate their kind response as I have received Wait stats from my readers. I took each of the results and carefully analyzed them. I…

SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor

January 31, 2011

Pinal Dave

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

SQL Index

Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest…

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

January 19, 2011

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011

Pinal Dave

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

SQL Scripts

Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here. Read second part over here: Quick…

SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer

January 7, 2011

Pinal Dave

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

SQL DMV, SQL Scripts

Incredibly, SQL Server has so much information to share with us. Every single day, I am amazed with this SQL Server technology. Sometimes I find several interesting information by just querying few of the DMV. And when I present this info in front of my client during performance tuning consultancy, they are surprised…

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

January 6, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My association with SQL Server Magazine has been quite long, I have written nearly 7 to 8 SQL Server articles for the print magazine and it has been a…

SQL SERVER – Unused Index Script – Download

January 4, 2011

Pinal Dave

SQL Performance

SQL Download, SQL Index, SQL Scripts, SQL Server

Performance Tuning is quite interesting and Index plays a vital role in it. A proper index can improve the performance and a bad index can hamper the performance. Here is the script from my script bank, which I use to identify unused indexes on any database. Let us see script for unused index.