SQL Server Archives - Page 208 of 393 - SQL Authority with Pinal Dave

SQL SERVER – DMV – sys.dm_os_wait_stats Explanation – Wait Type – Day 3 of 28

February 3, 2011

The key Dynamic Management View (DMV) that helps us to understand wait stats is sys.dm_os_wait_stats; this DMV gives us all the information that we need to know regarding wait stats. However, the interpretation is left to us. This is a challenge as understanding wait stats can often be quite tricky. Anyway, we will…

SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28

February 2, 2011

Pinal Dave

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

SQL DMV, SQL Scripts, SQL Wait Stats

In this post, let’s delve a bit more in depth regarding wait stats. The very first question: when do the wait stats occur? Here is the simple answer. When SQL Server is executing any task, and if for any reason it has to wait for resources to execute the task,…

SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28

February 1, 2011

Pinal Dave

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

SQL Wait Stats

This blog post will have running account of the all the blog post I will be doing in this month related to SQL Server Wait Types and Wait Queues. SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28 SQL SERVER – Signal…

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

February 1, 2011

Pinal Dave

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

SQL DMV, SQL Scripts, SQL Wait Stats

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 – Denali – SEQUENCE is not IDENTITY

January 30, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Yesterday I posted blog post on the subject SQL SERVER – 2011 – Introduction to SEQUENCE – Simple Example of SEQUENCE and I received comment where user was not clear about difference between SEQUENCE and IDENTITY. The reality is that SEQUENCE not like IDENTITY. There is very clear difference between…

SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE

January 29, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

SQL Server 2011 will contain one of the very interesting feature called SEQUENCE. I have waited for this feature for really long time. I am glad it is here finally. SEQUENCE allows you to define a single point of repository where SQL Server will maintain in memory counter. USE AdventureWorks2008R2…