Browse by Tags

SQL Server BI - Managing Large Datawarehouse environment, guidelines

Published 17 September 8 3:24 AM | SqlServer-QA.net

What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...

Filed under: sql server, performance, management, databases, reporting, business intelligence, data warehouse, readonly

Guidelines for enabling indexes and online index operations

Published 8 October 7 8:50 AM | SSQA.net

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

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