SSIS / SQL Server / 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

• Categories

  • BEST PRACTICE
  • CROSS JOIN
  • DMV's
  • dm_db_index_physical_stats
  • dm_db_index_usage_stats
  • Execution Plan
  • Fragmentation
  • Index Fragmentation
  • Index tuning
  • Index usefulness
  • Indexes
  • Optimize
  • Oracle Oledb Provider
  • Parameter Sniffing
  • Performance
  • Performance Tuning
  • Profiler
  • Queries running on the server
  • Query hint
  • RBAR
  • RECOMPILE hint
  • SEEK vs Scan
  • SET BASED
  • slow start
  • sp_who
  • sp_who2
  • sp_whoisactive
  • SQL Server 2005
  • SQL Server 2005 features
  • SQL Server 2008 R2
  • SSIS
  • SSMS
  • stored procedure
  • system monitoring
  • Tips
  • Triangular Join
  • TSQL
  • XML Execution Plan

• Archives

  • February 2017
  • November 2014
  • September 2012
  • February 2012
  • October 2010
  • March 2009
  • July 2008
  • March 2008
  • January 2008
  • December 2007
  • August 2007

• Feeds

• Full
• Comments