Browse by Tags

• best
• dashboard
• databases
• disk
• dml
• filtered
• indexes
• management
• monitoring
• optimization
• sql server
• statiscs age
• worst

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

Guidelines for enabling indexes and online index operations
08 October 07 06:50 AM | SQL Master | 4 Comments   

As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and Read More...

Filed under: performance, sql server, management, indexes, databases, dashboard, indexed view, monitoring

Best and Worst of having indexed views in SQL 2005
30 July 07 08:15 AM | SQL Master | 7 Comments   

Consider to have indexed view if the queries are accessing using a f requently occurring aggregations and joins. Irrespective of whether or not a query is asked frequently, it may be a candidate for an indexed view if it takes significant time to answer, Read More...

Filed under: performance, disk, indexed view, worst, best