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

SQL SERVER – Checklist for Analyzing Slow-Running Queries

March 12, 2010

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

I am recently working on upgrading my class Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning with additional details and more interesting examples. While working on slide deck I realized that I need to have one solid slide which talks about checklist for analyzing slow running queries. A…

SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint

March 11, 2010

Pinal Dave

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

SQL Index, SQL Scripts

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and…

SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index

March 9, 2010

Pinal Dave

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

SQL Index, SQL Scripts

This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO. Let us kick off this post with disclaimers about Index. Index…

SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT

March 3, 2010

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server

Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options.

SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010

March 2, 2010

Pinal Dave

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

CDC, Database, MVP, SQL Index, SQL User Group, SQLAuthority Author Visit

TechEd Sri Lanka was held at Waters Edge, Colombo between Feb 8 and Feb 10, 2010. It was one of the largest successful technical event in Sri Lanka. I was extremely surprised to how technically sound this event was and how excited the TechEd attendees were. I presented there on…

SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement

March 1, 2010

Pinal Dave

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

SQL Data Storage, SQL Index, SQL Scripts

The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression. Data compression implies the reduction in the disk space reserved by…

SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance

February 28, 2010

Pinal Dave

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

SQL Index, SQL User Group

I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review. I really had…