Browse by Tags

• agent
• dml
• filtered
• index
• indexed view
• indexes
• optimization
• performance
• process
• query
• sql server
• statistics
• timeout

SQL Server Performance - consideration on unique index or filtered index.
25 September 08 12:46 AM | satyaskj | 2 Comments   

It is no doubt that when a database consists ' well-designed ' indexes can reduce disk I/O operations and consume fewer system resources therefore improving query performance. You might be wondering I'm going back to basics for indexes! So when the database Read More...

Filed under: performance, sql server, indexes, optimization, indexed view, statiscs age, dml, filtered

SQL Server 2005 methods to find table INDEX or Statistics age for better performance
09 January 08 01:55 AM | SQL Master | 4 Comments   

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller Read More...

Filed under: performance, sql server, query, process, agent, statistics, index, timeout, statiscs age