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 is an advantage to avoid the costs and pre-requisite...
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 on a multiprocessor computer that uses NUMA architecture...
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 ensure to have SQL Server client tools installed...