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

SQL SERVER – 2008 – High Availability – Hot Add Memory

June 30, 2008

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

After reading my previous article about SQL SERVER – 2008 – High Availability – Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory. Yes, there are few restictions to Hot Add Memory as well. I am listing…

SQL SERVER – 2008 – High Availability – Hot Add CPU

June 28, 2008

Pinal Dave

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

SQL Server Security

One of team member suggested that we should upgrade to SQL Server 2008 because its new feature is very cool “Hot Add CPU”. Yes, I agree it is very cool feature. I am eagerly waiting for RTM of SQL Server 2008 so I can upgrade our servers to SQL Server…

SQL SERVER – 2008 – Inline Variable Assignment

June 15, 2008

Pinal Dave

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

SQL Scripts

I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable. ---- SQL Server 2005 Way…

SQL SERVER – Order Of Column In Index

June 2, 2008

Pinal Dave

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

SQL Index, SQL Joins, SQL Scripts

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…