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

SQL SERVER – Query to Find Duplicate Indexes – Script to Find Redundant Indexes

July 13, 2011

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

I was recently delivering session on Performance Tuning subject. I was asking if there is any harm having duplicate indexes. Of course, duplicate indexes are nothing but overhead on the database system. Database system has to maintain two sets of indexes when it has to do update, delete, insert on…

SQL SERVER – Find Details for Statistics of Whole Database

June 29, 2011

Pinal Dave

SQL Performance

SQL DMV, SQL Scripts, SQL Server, SQL Statistics

I was recently asked is there a single script which can provide all the necessary details about statistics for any database.

SQL SERVER – Three Puzzling Questions – Need Your Answer

June 7, 2011

Pinal Dave

SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Scripts

Last week I had asked three questions on my blog. I got very good response to the questions. I am planning to write summary post for each of three questions next week. Before I write summary post and give credit to all the valid answers. I was wondering if I…

SQL SERVER – BI Quiz – Troubleshooting Cube Performance

June 6, 2011

Pinal Dave

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

Business Intelligence

My friend Jacob Sebastian runs SQL BI Quiz competition. Where there are 30 different questions on each day of the month. Winners get opportunity to participate in this Quiz, learn something new and win great awards. Working with huge data is very common when it is about Data Warehousing. It…

SQL SERVER – Puzzle – Statistics are not Updated but are Created Once

June 2, 2011

Pinal Dave

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

SQL Index, SQL Statistics

After having excellent response to my quiz – Why SELECT * throws an error but SELECT COUNT(*) does not?I have decided to ask another puzzling question to all of you. I am running this test on SQL Server 2008 R2. Here is the quick scenario about my setup. Create Table…

SQL SERVER – Cartoon Challenge – 140 Character Winner is Here

May 4, 2011

Pinal Dave

Personal, SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

Database, MVP, SQL Scripts

Earlier Idera has announced contest where participant can win Windows Mobile Phone by writing 140 character. Here is the details of the contest SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL. We received more than 200 comments on the blog post…

SQL SERVER – TempDB in RAM for Performance

April 10, 2011

Pinal Dave

SQL Performance

SQL Server, SQL TempDB

Performance Tuning is always the most interesting subject when we talk about software application. While I was recently discussing performance tuning with my friend, we started to talk about the best practices for TempDb. I also pointed my friend to the excellent blog post written by Cindy Gross on the subject: Compilation of SQL Server TempDB IO Best Practices. One of the discussion points was that we should put TempDB on the drive which is always giving better performance.