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

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server

August 12, 2010

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

I was recently called to attend the Query Tuning Project. I had a very interesting experience in this event. I would like to share to you what actually happened. Note: If you are just going to say that shrinking database is bad, I agree with you and that is the…

SQL SERVER – Computed Column – PERSISTED and Performance – Part 2

August 4, 2010

Pinal Dave

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

SQL Scripts

This is the third article in the series which I am writing on Persisted Columns. I suggest you read following two article first before continuing on this article. This is the list of the all the articles in the series of computed column. SQL SERVER – Computed Column – PERSISTED…

SQL SERVER – Computed Column – PERSISTED and Performance

August 3, 2010

Pinal Dave

SQL Performance

Computed Column, SQL Scripts, SQL Server

This is the list of the all the articles in the series of computed column.

SQL SERVER – Find Queries using Parallelism from Cached Plan

July 24, 2010

Pinal Dave

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

Best Practices, SQL DMV, SQL Scripts, SQL Server

I recently came across wonderful blog post of Feodor Georgiev. He is one fine developer and like to dwell in the subject of performance tuning and query optimizations. He is one real genius and original blogger. Recently I came across his wonderful script, which I was in fact writing myself…

SQL SERVER – Identifying Statistics Used by Query

July 19, 2010

Pinal Dave

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

SQL Scripts

“Can I know which statistics were used by my query?” Recently, someone asked this question in my training class of query optimization and performance tuning. I really liked the question. The answer for me is very simple. “No.” Well, if I stop here suggesting only “No,” it will be an…

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial

July 1, 2010

Pinal Dave

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

Best Practices, SQL Utility

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed…

SQL SERVER – Outer Join Not Allowed in Indexed Views

June 29, 2010

Pinal Dave

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

SQL Index, SQL Joins, SQL Scripts, SQL Statistics

I recently received an email that contains a question from one of my readers. I have already replied the answer to his email, but I would still like to bring it to your attention and ask if you think I could have done any better with the example I gave.…