Browse by Tags

• best practice
• dmv
• fragmentation
• index
• indexed views
• indexes
• log
• optimization
• performance
• query
• security
• sql server
• statistics
• tempdb
• tsql

Update Statistics on huge tables - best practice
23 October 07 04:40 AM | SQL Master | 2 Comments   

If you have valid indexes and they are maintained with regular schedule of reindexing to address fragmentation, then you can go with UPDATE STATISTICS on the tables that has frequent updates, say once in 2 days during the quiet time on the databases. Read More...

Filed under: performance, sql server, indexes, update statistics, best practice, indexed views

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

Usage and good practices with UPDATE STATISTICS feature in SQL 2005
23 July 07 03:39 AM | SQL Master | 1 Comments   

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be Read More...

Filed under: performance, security, query, dmv, optimization, tsql, statistics, update statistics