Browse by Tags

All Tags » 2005 (RSS)
Cumulative Update 8 package for SQL Server 2005 Service Pack2
Published 16 July 8 4:50 AM | SSQA.net
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...
Filed under: , , , , , ,
Get ready for SQL Server 2008 RTM release!
Published 14 July 8 9:56 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
Reporting Services 2008 additional features, other than SQL Server Reporting Services 2005
Published 11 July 8 4:38 AM | SSQA.net
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...
Filed under: , , , , ,
KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues
Published 12 June 8 10:2 PM | SSQA.net
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...
Filed under: , , , , , ,
SQL Server 2005 Performance Dashboard
Published 12 June 8 6:25 AM | SSQA.net
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...
Filed under: , , ,
SQL Server High Number of User Connections found on PERFMON, how to resolve it?
Published 3 June 8 3:7 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy
Published 29 May 8 4:11 AM | SSQA.net
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...
Filed under: , , , , , , ,
Support Webcast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008
Published 19 May 8 2:53 PM | SSQA.net
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...
Filed under: , , , ,
SQL Server Locking
Published 18 May 8 2:30 AM | SSQA.net
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...
Filed under: , ,
SQL Server Statistics
Published 16 May 8 3:0 AM | SSQA.net
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...
Filed under: , ,
SQL Server and Windows Memory
Published 15 May 8 9:2 AM | SSQA.net
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...
Filed under: , , , , ,
FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
Published 15 May 8 3:14 AM | SSQA.net
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...
Filed under: , , , , ,
A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
Published 12 May 8 1:43 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...
Filed under: , , , , , ,
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 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object
Published 22 April 8 3:1 AM | SSQA.net
Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was...
Filed under: , , , , , , ,
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
Published 21 April 8 3:1 AM | SSQA.net
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...
Filed under: , , , , , , , ,
SQL Server 2005 Service Pack 3 - work started
Published 15 April 8 4:37 PM | SSQA.net
Ok here is the hot news for SQL 2005 users!!! From the Are you ready for SP3 post here, it has been officially announced the SP3 for SQL Server 2005 will be available in CY2008 (calender year 2008) that means before 31st December 2008! More from this...
Filed under: , , , , ,
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues
Published 9 April 8 2:22 AM | SSQA.net
Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime...
Filed under: , , , , , , , , , ,
End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
Published 8 April 8 2:2 AM | SSQA.net
The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...
Filed under: , , , , , , , , , ,
SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?
Published 18 March 8 4:20 AM | SSQA.net
First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...
Filed under: , , , , , , , , , , ,
More Posts Next page »