Browse by Tags

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

SQL Server indexing - when to reorganize or rebuild?

Published 21 January 8 4:30 AM | SSQA.net

Re-organizing or rebuilding index would help the SQL optimizer to reduce the fragmentation for a better performance. In this case few users might have doubt that when to rebuild or reorganize (SQL Server 2005)? IN the series of Performance blog posts...

Filed under: sql server, indexes, msdn, blogs, rebuild, schema, best practice, schedule, links, performance monitoring, reorganize

SQL Server Query Performance - think about page split and fragmentation, measures to reduce the behaviour and best use of dm_db_index_physical_stats DMV

Published 14 January 8 2:22 AM | SSQA.net

It is an universal truth in the database field that due to the fragmentation and page split the performance will be affected even for a simple [ SELECT <ColumnName> from.... ] type of query. So what you need to check or take action in terms of DBA...

Filed under: sql server, performance, indexes, maintenance plan, dmv, dba, best practice, performance monitoring, sys.dm_db_index_physical_stats, measures

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Published 30 October 7 10:41 PM | SSQA.net

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide

Update Statistics on huge tables - best practice

Published 23 October 7 6:40 AM | SSQA.net

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....

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

Disk Space Requirements for Index DDL Operations

Published 28 September 7 8:38 AM | SSQA.net

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information...

Filed under: sql server, performance, indexes, dba, optimization, disk space, best practice, hardware, disks, sorting, reindexing