All Articles - 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 – 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…

SQLAuthority News – Deployment guide for Microsoft SharePoint Foundation 2010

January 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SharePoint

SharePoint and SQL Server both goes together – hands to hand. SharePoint installation is very interesting. At various organizations, the installation is very different and have various needs. SQL Server installation with SharePoint is equally important and I have often seen that it is being neglected. Microsoft has published the…

SQL SERVER – What is a Technology Evangelist?

January 27, 2011

Pinal Dave

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

Database, MVP

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church. In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith. In the technology world, the same definition is true. Technology…

SQL SERVER – Reducing Page Contention on TempDB

January 26, 2011

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL TempDB

I have recently received following email asking about how to reduce page contention on TempDB.

“We are using Trace Flag 1118 to reduce the tempDB contention on our servers (2000 and 2005). What is your opinion?

We have read lots of material, would you please answer me in single line.”

SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V

January 25, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

While I was writing my earlier post SQL SERVER – 2011 – Multi-Monitor SSMS Windows, I found out that there is one more similar feature which existed in Visual Studio is also now part of SQL Server 2011 (Denali). The feature is called clipboard ring feature. This is how it works.…

SQL SERVER – Denali – Multi-Monitor SSMS Windows

January 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

I have a dual screen arrangement at my home system. I love it because it’s very convenient. When I am working with SQL Server 2008 R2 or any earlier versions, I would want to use both of the Monitor so I open two separate SQL Server Management Studio and work along…

SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback

January 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

SQL Server Analysis Service have many features which are commonly requested and many already exists in the system. Security Data Entry is very important feature and SSAS supports writeback feature. Analysis Services is a tool for aggregating information and providing business users with the ability to analyze and support decision…