SqlServer-QA.net

Data Dude - if you know about these 2 words then you know what I'm talking about. Visual Studio Team Edition for Database Professionals is an excellent tools for the users  to build SQL databases in a managed project environment with support for versioning, deployment, unit testing, refactoring, and off-line SQL development. SO what's that ...

As it seems the error text on the subject looks familiar when you have installed SQL Server or working with SQL Server databases. How about getting the error on Analysis Services databases (OLAP) within your BI Platform. So in the case of handling the Business Intelligence platform you must be aware of necessary data providers that are ...

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate) and tried to install afresh on a central monitoring server (Windows 2003 server) ...

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be  listed on this  Windows Catalog and Hardware Compatibility, otherwise you may not be able to utilize or install full set of clustering ...

I was happy to see that February CTP for SQL Server 2008 was ready to download for use, in coinciding with my presentation in SQLBits I wanted to work my demos on this CTP release, nothing worked out successfully!! It is fair that new release will help developers and DBAs to test their solutions and get familiar with the next CTP of SQL ...

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled, the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL Server 2005, obviously SQLAgent is important part of SQL Server tasks that you need to schedule on ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: Error message when you start a database mirroring session in SQL Server 2005: ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications FIX: You must restart the SQL Server service on the principal server after you resume the SQL Server service process from a debug tool in SQL Server ...

Imagine a simple installation of SQL Server Express 2005 edition fails with an error ''SQL Server service failed to start?'' Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default install options. When the installation fais always best to check the error log for the reason ...

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 you would expect are not upto the mark, when using indexing tuning wizard or by updating ...