SqlServer-QA.net

Have you ever been in a situation that one of the database has been giving hard time!It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that database is located and further you might see the errors (may familiar to you):2008-11-08 ...

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build a highly available SQL Server solution. The customer required automatic failover between the sites ...

As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all the work including from SP2 as well as addresses critical issues reported through the SQL ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New FIX: A SQL Server Agent job that creates a ServerXMLHTTP object by using an ActiveX script remains in the Executing status and is never completed in SQL Server 2005http://support.microsoft.com/kb/958555/en-USNew 10/20/2008 8:16:00 PM GMT FIX: ...

The support policy for SQL Server running on virtualised platforms has now been updated to include support for SQL Server 2005 running on Hyper-V http://support.microsoft.com/?id=956893 Microsoft provides technical support for SQL Server 2005 and for SQL Server 2008 that are running in the following hardware virtualization ...

I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA 951217 here. Obviously this is for the installations that will have SQL Server 2005 SP2 and ...

Are you desperate to get Relase To Manufacturing (RTM) release of SQL Server 2008? Well, long wait for SQL Server 2008 is nearly over. It is an official announcement that SQL Server 2008 will be on the August price list.  This means that customers and partners will soon be able to place their orders for SQL Server 2008 as we get ready to ...

SQL Server Reporting Services has been introduced in 2000 version but not catched within the user environment until the Reporting Services 2005 has been rolled out. In this regard administering a Reporting Services installation requires that you know how to perform routine maintenance tasks for server components, and how to manage the content and ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled ...

I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers to monitor the general performance characteristics of a server and investigate the cause of any ...