Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » 2005   (RSS)
Sunday, March 15, 2009 11:12 PM

SQL Server 2005 Multi-Site Clustering with Windows Server 2008

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
Posted by robcarrol | 2 Comments
Wednesday, October 08, 2008 4:48 PM

Updated: Support Policy for SQL Server on Virtualised Platforms

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
Posted by robcarrol | 1 Comments
Thursday, June 12, 2008 12:25 PM

SQL Server 2005 Performance Dashboard

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
Posted by robcarrol | 2 Comments
Monday, May 19, 2008 8:53 PM

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

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
Posted by robcarrol | 2 Comments
Sunday, May 18, 2008 8:30 AM

SQL Server Locking

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
Posted by robcarrol | 2 Comments
Filed under: , ,
Friday, May 16, 2008 9:00 AM

SQL Server Statistics

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
Posted by robcarrol | 6 Comments
Thursday, May 15, 2008 3:02 PM

SQL Server and Windows Memory

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
Posted by robcarrol | 2 Comments
 
Page view tracker