SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : 2005

SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes

Thu, 20 Aug 2009 14:21:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Edition and SQL Server 2008 Enterprise Edition Notification Contents: New and Major Modifications SQL Server 2005 and SQL Server 2008 reports...(read more)

SQL Server 2005 Service Pack 3 (SP3) is released

SqlServer-QA.net — Tue, 16 Dec 2008 08:15:00 GMT

From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News...(read more)

Download SQL Server 2005 Books Online - Updated DECEMBER 2008

SqlServer-QA.net — Mon, 15 Dec 2008 07:37:00 GMT

Here is another update on Books Online (BOL) for SQL Server 2005 - Download an updated version of the documentation and tutorials, to see what kind of updates are updated in the documentation once you downloaded & install see the " Additional...(read more)

Recover a database with no transaction log file - SQL Server 2005!

SqlServer-QA.net — Tue, 11 Nov 2008 07:16:00 GMT

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...(read more)

SQL Server 2005 Multi-Site Clustering with Windows Server 2008

SqlServer-QA.net — Sun, 02 Nov 2008 16:20:00 GMT

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...(read more)

SQL Server 2005 Service Pack 3 - public beta for your action

SqlServer-QA.net — Thu, 30 Oct 2008 15:48:00 GMT

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...(read more)

SQL Server 2005 Enterprise & Standard Editions Knowledge Base Notifications

SqlServer-QA.net — Tue, 21 Oct 2008 16:40:00 GMT

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification 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...(read more)

Updated: Support Policy for SQL Server on Virtualised Platforms

SqlServer-QA.net — Wed, 08 Oct 2008 15:48:00 GMT

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...(read more)

Cumulative Update 8 package for SQL Server 2005 Service Pack2

SSQA.net — Wed, 16 Jul 2008 09:50:00 GMT

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...(read more)

Get ready for SQL Server 2008 RTM release!

SSQA.net — Mon, 14 Jul 2008 14:56:00 GMT

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 is set to RTM'd during the month of August 2008, as per Bob...(read more)

Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005

SSQA.net — Fri, 11 Jul 2008 09:38:00 GMT

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...(read more)

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

SSQA.net — Fri, 13 Jun 2008 03:02:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New SQL Server 2005 installers...(read more)

SQL Server 2005 Performance Dashboard

SSQA.net — Thu, 12 Jun 2008 11:25:00 GMT

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...(read more)

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

SSQA.net — Tue, 03 Jun 2008 08:07:00 GMT

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...(read more)

Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy

SSQA.net — Thu, 29 May 2008 09:11:00 GMT

Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected...(read more)

Support Webcast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008

SSQA.net — Mon, 19 May 2008 19:53:00 GMT

A new Level 300 support webcast has been scheduled for Monday the 9th of June, 10:00 AM Pacific Time. The summary of the session is as follows: This Support WebCast focuses on how to plan, implement, and administer a Microsoft SQL Server 2005 failover...(read more)

SQL Server Locking

SSQA.net — Sun, 18 May 2008 07:30:00 GMT

Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as by...(read more)

SQL Server Statistics

SSQA.net — Fri, 16 May 2008 08:00:00 GMT

SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow...(read more)

SQL Server and Windows Memory

SSQA.net — Thu, 15 May 2008 14:02:00 GMT

SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve...(read more)

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

SSQA.net — Thu, 15 May 2008 08:14:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: An ongoing MS DTC transaction is...(read more)