SQL Server 2005 Performance Tuning

Furrukhbaig’s Weblog

• Home
• About Me

• About...

  It my passion to find out internals of database engine and optimizer to make our code more useful and optimal.

  I have start writing this blog to keep all the useful script and techniques in one place where I can alway refer back. The other reason is to share thought with others in community.

  I have been doing Performance Tuning and code refactoring work for many years and have used SQL 6.5/ 7.0/ 2000/ 2005 and now 2008.

• Admin Controls

  • Log in

• a

  Select Category BEST PRACTICE  (1) CROSS JOIN  (1) DMV’s  (8) dm_db_index_physical_stats  (2) dm_db_index_usage_stats  (2) Execution Plan  (4) Fragmentation  (1) Index Fragmentation  (1) Index tuning  (3) Index usefulness  (3) Indexes  (7) Optimize  (6) Parameter Sniffing  (1) Performance  (14) Performance Tuning  (5) Profiler  (1) Queries running on the server  (2) Query hint  (2) RBAR  (1) RECOMPILE hint  (1) SEEK vs Scan  (1) SET BASED  (1) slow start  (1) sp_who  (1) sp_who2  (1) sp_whoisactive  (1) SQL Server 2005  (15) SQL Server 2005 features  (6) SSMS  (1) stored procedure  (2) system monitoring  (1) Tips  (5) Triangular Join  (1) TSQL  (10) XML Execution Plan  (3)

• Archives

  • October 2010
  • March 2009
  • July 2008
  • March 2008
  • January 2008
  • December 2007
  • August 2007

• SQL Server

  • Kalen Delaney
  • Kimberly L. Tripp – Indexing Guru
  • SQL Team

• SSIS

  • Frank Bazan
  • SQL Team

• Tips

  • Kalen Delaney
  • Kimberly L. Tripp – Indexing Guru
  • SQL Team
  • Useful Tips

• Feeds

• Full
• Comments