SQL Index Archives - Page 26 of 47 - SQL Authority with Pinal Dave

SQLAuthority News – Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index

September 26, 2011

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

Performance Tuning has been my favorite subject always. I love this subject the most. I personally have enjoyed every aspect of performance tuning. Quite often I have seen that when it is about performance, people end up talking about Indexes. Index for sure can help performance, but it is like…

Puzzle – Usage of New Index Hints – ForceSeek and ForceScan

September 23, 2011

Pinal Dave

SQL Puzzle

Query Hint, SQL Index, SQL Server

Tomorrow is the weekend. I just thought, let us explore something new but a quick puzzle to explore about index hints.

SQL Server Denali has new Query Hint – FORCESCAN. In earlier version of SQL Server we already have Query Hint FORCESEEK but now the counter part also exists. The quick understanding is there will be cases when FORCESEEK or FORCESCAN will be helpful and improve the performance of the query.

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

July 13, 2011

Pinal Dave

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

SQL Index, SQL Scripts

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…

Interview Questions and Answers – Frequently Asked Questions – Day 6 of 31

July 6, 2011

Pinal Dave

SQL Interview Questions and Answers

SQL Constraint and Keys, SQL Index, SQL Server

Please read the Introductory Post before continuing reading interview questions and answers. Some more questions are included in the blog.

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

June 17, 2011

Pinal Dave

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

SQL Index, SQL Scripts, SQL Statistics

Earlier I asked puzzle why statistics are not updated. Read the complete details over here: Statistics are not Updated but are Created Once In the question I have demonstrated even though statistics should have been updated after lots of insert in the table are not updated.(Read the details SQL SERVER –…

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…

SQLAuthority News – Win Windows Phone from Idera in 140 Characters – A Cartoon Challenge of SQL

April 5, 2011

Pinal Dave

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

SQL Index

I personally have Windows Phone and I love it. The user friendliness and integration with social media is remarkable. My wife Nupur is big fan of Windows Live tools and Windows Phone as well. Well, this blog post is not about our preference of Windows Phone but about YOU a…