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

SQL SERVER – Identifying Statistics Used by Query

July 19, 2010

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

“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.…

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache

June 17, 2010

Pinal Dave

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

SQL DMV, SQL Scripts

This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually…

SQL SERVER – Difference Between DATETIME and DATETIME2

June 11, 2010

Pinal Dave

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

SQL DateTime, SQL Scripts

Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing with this blog post today. I had asked people to honestly take part and share…

SQL SERVER – Fastest Way to Restore Database

June 9, 2010

Pinal Dave

SQL Performance

SQL Restore, SQL Server

A few days ago, I received following email from blog reader where the question was about the fastest way to restore database.

SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2

June 7, 2010

Pinal Dave

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

SQL Joins, SQL Scripts

This blog post is part 2 of the earlier written article SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best by Paulo R. Pereira. Paulo has left excellent comment to earlier article once again proving the point that SQL Server Engine is smart…