Browse by Tags

SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?

Published 12 May 8 4:25 AM | SSQA.net

Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which...

Filed under: sql server, databases, best practices, database mirroring, 2005, principal, witness, mirror, timeout

FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005

Published 16 December 7 6:57 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A federated database server stops responding when you run parallel queries...

Filed under: sql server, databases, x64, 2005, multi-processor, parallel queries, numa, federated, architecture

"Provider cannot be found" error when trying to run a MDX query?

Published 5 November 7 2:39 AM | SSQA.net

One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error...

Filed under: sql server, mdx, databases, 2005, Analysis Services, adomd.net, feature pack, driver