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

SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries

September 29, 2009

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

Working with SQL Server has never seems to be monotonous – no matter how long one has worked with it. Quite often, I come across some excellent comments that I feel like acknowledging them as blog posts. Recently, I wrote an article on SQL SERVER – Execution Plan and Results…

SQL SERVER – Outer Join in Indexed View – Question to Readers

September 25, 2009

Pinal Dave

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

SQL Index, SQL Joins, SQL View, SQL White Papers

Today I have question for you. Just a day ago I was reading whitepaper Improving Performance with SQL Server 2008 Indexed Views. Following is question and answer I read in the white paper. Q. Why can’t I use OUTER JOIN in an indexed view? A. Rows can logically disappear from…

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

September 24, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL White Papers

Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…

SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note

August 24, 2009

Pinal Dave

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

SQL Index, SQL Server

In this article we shall examine the two modes of data search and retrieval using indexes- index seek and index scan, and the differences between the two.

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

August 11, 2009

Pinal Dave

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

Database, DBA, SQL Constraint and Keys, SQL Index

About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…

SQL SERVER – Maximum Number of Index per Table

June 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees actively participating in the sessions. We had attendees traveling from far and wide, including Delhi, Mumbai, Jaipur, Kerala, Baroda, Himmatnagar, Rajkot, among other cities from India. This enthusiastic participation made the event…

SQL SERVER – Clustered Index on Separate Drive From Table Location

June 18, 2009

Pinal Dave

SQL Performance

Best Practices, SQL Constraint and Keys, SQL Index, SQL Server

How to improve performance of SQL Server Queries is a common topic of discussion among many of us. Much has been said, much has been discussed. Few days back, I had an interesting discussion with one of the Junior developers regarding performance improvement of SQL Server Queries. We discussed on how by using a separate hard drive for several database objects can right away improve performance. I suggested him that non clustered index and tempdb can be created on a separate disk to improve performance.