Blogs about: Sql Optimization
Featured Blog
SQL SERVER - 2005 2008 - Backup, Integrity Check and Index Optimization By Ola Hallengren
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 … more →
Journey to SQL Authority with Pinal Dave
SQL SERVER - Remove Bookmark Key Lookup - 4 Different Ideas
pinaldave wrote 2 days ago: I quite often get request to summarized my ideas about Removing bookmark lookup on this blog post. B … more →
SQL SERVER - 2005 2008 - Backup, Integrity Check and Index Optimization By Ola Hallengren
— 2 comments
pinaldave wrote 1 week ago: Script of Backup, Integrity Check and Index Optimization are the most important scripts for any deve … more →
SQL Authority News - Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
— 14 comments
pinaldave wrote 2 weeks ago: This is very short note announcing details about my course details for ‘MS SQL Server 2005/200 … more →
SQL SERVER - Removing Key Lookup - Seek Predicate - Predicate - An Interesting Observation Related to Datatypes
— 4 comments
pinaldave wrote 2 weeks ago: Recently, I have been working on Query Optimization project. While working on it, I found the follow … more →
SQL SERVER - Tuning the Performance of Change Data Capture in SQL Server 2008
— 1 comment
pinaldave wrote 3 weeks ago: Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, me … more →
SQLAuthority News - PASS 2009 Sessions on Query Optimization and Performance Tuning
— 4 comments
pinaldave wrote 1 month ago: PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to atte … more →
SQL SERVER - Query Optimization - Remove Bookmark Lookup - Remove RID Lookup - Remove Key Lookup - Part 3
— 1 comment
pinaldave wrote 1 month ago: Earlier I have written two different articles on the subject Remove Bookmark Lookup. This article is … more →
SQL SERVER - Download Logical Query Processing Poster
— 1 comment
pinaldave wrote 1 month ago: Download Logical Query Processing Poster Earlier this year, I had written article on SQL SERVER – Lo … more →
SQL SERVER - Query Optimization - Remove Bookmark Lookup - Remove RID Lookup - Remove Key Lookup - Part 2
— 7 comments
pinaldave wrote 1 month ago: This article is follow up of my previous article SQL SERVER – Query Optimization – Remov … more →
SQL SERVER - Query Optimization - Remove Bookmark Lookup - Remove RID Lookup - Remove Key Lookup
— 18 comments
pinaldave wrote 1 month ago: Today, I would like to share one very quick tip about how to remove bookmark lookup or RID lookup. L … more →
SQL SERVER - Interesting Observation - Query Hint - FORCE ORDER
— 10 comments
pinaldave wrote 1 month ago: SQL Server never stops to amaze me. As regular readers of this blog already know that besides conduc … more →
Optimize Joins and Query Plan Changes
mohibalvi wrote 5 months ago: Joins and Query Plans Details of the article can be viewed at ask Tom Below are two queries posted b … more →
SQL SERVER - Clustered Index on Separate Drive From Table Location
— 7 comments
pinaldave wrote 5 months ago: How to improve performance of SQL Server Queries is a common topic of discussion among many of us. M … more →
SQL SERVER - Effect of Normalization on Index and Performance
— 5 comments
pinaldave wrote 5 months ago: Of late, I have been using Twitter quite frequently, and I am gradually discovering its usefulness. … more →
Basic SQL Performance Diagnosis
mohibalvi wrote 5 months ago: Article is based on Randolf’s Post on Basic SQL statement performance diagnosis-HOW TO The fo … more →
Creating SQL Tuning Task
mohibalvi wrote 6 months ago: DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB; BEGIN my_sqltext := ‘SELECT a16.mkt_oid … more →
SQL optimization using Oracle Hints
mohibalvi wrote 6 months ago: ORACLE HINT REFERENCE PARALLEL Scanning full table with parallel degree of 8. P … more →
SQL SERVER - Automated Index Defragmentation Script
— 10 comments
pinaldave wrote 7 months ago: Index Defragmentation is one of the key processes to significantly improve performance of any databa … more →
SQLAuthority News - Ahmedabad SQL Server User Group Meeting Review - March 21, 2009
— 5 comments
pinaldave wrote 8 months ago: We had fun session with Ahmedabad SQL Server Usre Group last week on March 21, 2009. It was short se … more →
