Browse by Tags

• best practice
• indexes
• joins
• query
• sql server
• stored procedure
• tuning
• update statistics

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

Performance Tuning - will I loss the indexing when using derived table?
21 August 07 01:19 AM | SQL Master | 2 Comments   

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables can Read More...

Filed under: tuning, performance, sql server, query, stored procedure, joins, indexed views