When does SQL performance start being affected by the size?
When does SQL performance start being affected by the size?  We are running SQL 2005 64bit on Windows 2003 Enterprise 64 bit server.  The database is over 1 tb.  When does MS SQL start to degrade with database size? 

Answer Question   |  April 12, 2010  2:17 PM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 (64-bit), SQL Server 2005 Enterprise Manager

SQL Server 2005 Legacy DTS fails when run as a job
When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

Answer Question   |  January 22, 2010  4:24 PM
excel, SQL Server 2005 (64-bit)

SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue
I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are for web server [...]

Answer Question   |  August 23, 2012  11:57 AM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server installation, Windows Server 2008

Deciding on a RAID Level for a 64-bit SQL Server 2005
I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which [...]

Answer Question   |  March 6, 2009  8:22 PM
RAID, RAID Level 1, RAID Level 1 +0, SQL Server 2005, SQL Server 2005 (64-bit)

Upgrading to a 64-bit SQL Server 2005 environment
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise Edition environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. The only issue we are having is determining a good baseline for the base memory to install. [...]

Answer Question   |  March 5, 2009  6:28 PM
SQL Server 2005 (64-bit), SQL Server memory, SQL Server upgrades

SQL Server 64-bit Memory Requirement
We are replacing an existing SQL Server 2005 32-bit environment with a new SQL Server 2005 64-bit Enterprise High availability environment. The new solution will be a 2-node Microsoft Cluster with SQL Server Cluster Server, all 64-bit Enterprise additions. What I have a problem determining is what is a good baseline for the base memory [...]

Answer Question   |  January 29, 2009  9:54 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server memory, SQL Server Upgrade

SQL 2005 32 bit – SQL 2005 64 bit
Moving from SQL 2005 32 bit – SQL 2005 64 bit. What are the problems which can be faced during this move.

Answer Question   |  December 2, 2008  9:16 PM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server migration

Upgrade SQL Server 2005 32-bit to SQL Server 2005 64 bit
Hi, We have one development server which is running on sql 2005 32 bit contains Databases ( including Tables, SPs, views, assemblies..etc) Applications ( .net 2.0 web application, crystal reports..etc) Note: now this databases & application is under development stage. But our plan is in future we need install SQL 2005 64 bit on QA [...]

Answer Question   |  November 28, 2008  6:51 AM
SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 (64-bit), SQL Server 2005 32-bit to 64-bit upgrade, SQL Server 2005 upgrades, SQL Server upgrades

Upgrading clustered SQL 2005 64 bit standard to enterprise
Does anyone have any steps on how to upgrade a clustered SQL 2005 64 bit standard edition to a clustered 64 bit enterprise edition ??

Answer Question   |  October 2, 2008  9:46 AM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server clustering, SQL Server upgrades

Job Database Mail to Sharepoint Server Entry
Hi…. I want to do … SQL schedule Job database mail to sharepoint server entry,,, Any idea to show the way. Coz I’m very new to sharepoint server. And I’m using SQL Server 2005 64 bit. Schedule Job database mail is currently working properly and I want to send these mail to SharePoint Server. Thx [...]

Answer Question   |  September 28, 2008  1:51 AM
Database Mail, SharePoint, SQL Server 2005, SQL Server 2005 (64-bit)

Error in the installation of SQL Server 2005 (64-bit)
We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log: *********************************** Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 11706 Date: 17/07/2008 Time: 14:01:43 User: KELTONJames.Marley Computer: SQL-SRV-1 Description: Product: Microsoft SQL Server Native Client — [...]

Answer Question   |  June 1, 2010  6:45 PM
Event log errors, SQL Server 2005, SQL Server 2005 (64-bit)

Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit
The proposed data warehouse platform will be a 64 bit platform – both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I’ll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

Answer Question   |  May 21, 2008  4:35 PM
64 bit architecture, Data warehouse, ETL, SQL Server 2005 (64-bit)

Can SQL Server 2005 32-bit and SQL Server 2005 64-bit co-exist on the same cluster machine?
Can SQL Server 2005 32 bit and SQL Server 2005 64 bit co-exist on the same cluster machine?

Answer Question   |  November 9, 2012  1:46 PM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server clustering, SQL Server integration/interoperability