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

SQL SERVER – Order Of Column In Index

June 2, 2008

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

I just found one of my Jr. DBA to create many indexes with lots of column in it. After talking with him I found out that he really does not understand how really Index works. He was under impression that if he has more columns in one index, that index…

SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance

May 21, 2008

Pinal Dave

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

Best Practices, Database

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…

SQL SERVER – Ideal TempDB FileGrowth Value

May 17, 2008

Pinal Dave

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

SQL Server, SQL TempDB

Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.

SQL SERVER – Orphaned MS DTC Transaction Information

May 14, 2008

Pinal Dave

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

SQL Error Messages, SQL Scripts

Few days ago, one of our application was crashing IIS application pool because of unhandled exception. After researched we figured out the case of it was orphaned MS DTC transaction. When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connection are working…

SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution

May 4, 2008

Pinal Dave

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

SQL Joins, SQL Scripts, SQL Server

I am proud on readers of this blog. One of the reader asked asked question on article SQL SERVER – Delete Duplicate Records – Rows and another reader followed up with nice quick answer. Let us read them both together.

SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article

April 26, 2008

Pinal Dave

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

Best Practices, Database

This article has been written by blog reader and SQL Server Expert Praveen Barath in response to my previous article SQL SERVER – Optimization Rules of Thumb – Best Practices. Well Query Optimizations rules are not limited. It depends on business needs as well, For example we always suggest to…

SQL SERVER – Optimization Rules of Thumb – Best Practices

April 25, 2008

Pinal Dave

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

Best Practices, SQL Index

There are few rules for optimizing slow running query. Let us look at them one by one see how it can help. Rule # 1 : Always look at query plan first. I always start looking at query plan. There is always something which catches eyes. I pay special attention…