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

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 6

April 2, 2013

This is the sixth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier four parts. On my production server I personally use embarcadero DB Optimizer for…

SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses

March 19, 2013

Pinal Dave

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

Pluralsight, SQL Index

I am presenting at TechEd India 2013 two SQL Server session. You can read about my session in this blog post. Yesterday I presented on topic SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions. Today I will be presenting on the subject Indexes – The Unsung Hero. If you are at…

SQLAuthority News – Presenting Two Technology Sessions at TechEd India 2013 – Today and Tomorrow

March 18, 2013

Pinal Dave

SQLAuthority News

SQL Index, SQL Server, TechEd

Every year I am looking forward to TechEd India as it presents a wonderful opportunity to meet community in first hand. Community is my passion and I love to get involved with it at every single opportunity it presents. This year once again I am presenting a technology session at TechEd India. I will be presenting two Technology Sessions on the following subject.

Here is something I promise – if you attend my session – when you walk out of my session you will immediate action items which you can use it for your production server and improve the performance of the database. Additionally, I will have some goodies with me for everyone. I will have a few of my books, free subscription access to Pluralsight’s library as well something totally interesting as a giveaway.

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

March 12, 2013

Pinal Dave

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

SQL Function, SQL Index

“Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often. This is true but this subject is hard to understand in a single statement. Let us see what it means and how to use the function in the WHERE clause. We will be using sample…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5

February 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

This is the fifth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier four parts. On my production server I personally use embarcadero DB Optimizer for…

SQL SERVER – Primary Key and NonClustered Index in Simple Words

February 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

I have been writing a weekly round up from my blog where I go over last six years of blog posts and pick the best posts from the pasts. While I do this, there are two major place where I focus 1) If there are change in features – I…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

January 17, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

This is the fourth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier three parts. On my production server I personally use embarcadero DB Optimizer for all…