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

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

March 2, 2010

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…

SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review

February 25, 2010

Pinal Dave

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

MVP, SQL Index, SQL Training, SQL User Group, SQLAuthority Author Visit

Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which…

SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning

February 18, 2010

Pinal Dave

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

SQL Index, SQL Scripts, SQL Stored Procedure, SQL System Table

Recompilation process is same as compilation and degrades server performance. In SQL Server 2000 and earlier versions, this was a serious issue but in SQL server 2005, the severity of this issue has been significantly reduced by introducing a new feature called Statement-level recompilation. When SQL Server 2005 recompiles stored…

SQL SERVER – Find Statistics Update Date – Update Statistics

January 25, 2010

Pinal Dave

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

SQL Index, SQL Scripts, SQL Statistics

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to…

SQL SERVER – Fragmentation – Detect Fragmentation and Eliminate Fragmentation

January 12, 2010

Pinal Dave

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

SQL Index, SQL Scripts

Q. What is Fragmentation? How to detect fragmentation and how to eliminate it? A. Storing data non-contiguously on disk is known as fragmentation. Before learning to eliminate fragmentation, you should have a clear understanding of the types of fragmentation. We can classify fragmentation into two types: Internal Fragmentation: When records…