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

SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren

November 17, 2009

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

Script of Backup, Integrity Check and Index Optimization are the most important scripts for any developer. SQL Expert and true SQL enthusiast Ola Hallengren is known for his excellent scripts. Please try it out and let me know what you think. The documentation is available on http://ola.hallengren.com/Documentation.html and the script…

SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint

November 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Index, SQL Scripts

Foreign Key and Check Constraints are two types of constraints that can be disabled or enabled when required. This type of operation is needed when bulk loading operations are required or when there is no need to validate the constraint. The T-SQL Script that does the same is very simple.…

SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning

November 10, 2009

Pinal Dave

SQLAuthority News

SQL Index, SQL Server, SQL Training

This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.

SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes

November 9, 2009

Pinal Dave

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

SQL Index, SQL Scripts

Recently, I have been working on Query Optimization project. While working on it, I found the following interesting observation. This entire concept may appear very simple, but if you are working in the area of query optimization and server tuning, you will find such useful hints. Before we start, let…

SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’

October 27, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

Many times I have seen that the index is disabled when there is large update operation on the table. Bulk insert of very large file updates in any table using SSIS is usually preceded by disabling the index and followed by enabling the index. I have seen many developers running…

SQL SERVER – Comic Slow Query – SQL Joke

October 13, 2009

Pinal Dave

SQLAuthority News

SQL Humor, SQL Index, SQL Server, SQLAuthority Author Visit

Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detailed report of the same at Community TechDays in Ahmedabad – A Successful Event. After the event, I received many emails requesting the comic slow query I had shown in my presentation.

SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3

October 12, 2009

Pinal Dave

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

SQL Index, SQL Scripts, SQL Server

Earlier I have written two different articles on the subject Remove Bookmark Lookup. This article is as part 3 of the original article. Please read the first two articles here before continuing reading this article.