Browse by Tags

• benchmarking
• blocking
• FAQ
• fragmentation
• index
• log
• maintenance plan
• monitoring
• msdn
• performance
• sql server
• table variable
• tablesample
• temp tables
• update statistics

SQL server Temporary Tables, Table Variables and Recompiles - interesting scenario
17 January 08 01:23 AM | SQL Master | 2 Comments   

Usage of Temporary tables or variables is a common scenario in SQL Server world, since SQL Server 2005 usage of TEMPDB references to the blog posts here: http://sqlserver-qa.net/blogs/tools/archive/2007/04/05/sql-server-index-optimization-best-practices.aspx Read More...

Filed under: performance, sql server, blocking, msdn, tablesample, tempdb, best practice, FAQ, monitoring, maintenance plan, benchmarking, table variable, temp tables

Update statistics causing negative performance
17 August 07 06:11 PM | SQL Master | 2 Comments   

Recently we have seen a negative performance for a query that is running against a 500GB size of database, where AUTO UPDATE STATISTICS is enabled and we perform weekly reindexing on this database. In addition to this I perform intermittent update statistics Read More...

Filed under: performance, sql server, fragmentation, update statistics, index, tempdb, log, best practice