Search Results | SQL Server Performance Forums

Post by: fwa, Apr 4, 2006 in forum: SQL Server 2005 General DBA Questions

Just wanted to update this thread.... I contacted Microsoft Product Support Services and opened a case on 3/16/2006. This was the first time I've...

Post by: fwa, Mar 15, 2006 in forum: SQL Server 2005 General DBA Questions

Ran the query with OPTION (FORCE ORDER) in 2005. Didn't seem to do anything.

Post by: fwa, Mar 15, 2006 in forum: SQL Server 2005 General DBA Questions

Here are the execution plans... SQL 2000 (SET SHOWPLAN_ALL ON) <pre id="code"><font face="courier" size="2"...

Post by: fwa, Mar 15, 2006 in forum: SQL Server 2005 General DBA Questions

Okay, I've identified another poor performer. I stripped out all of the extraneous code. To start fresh I dropped the databases and restored the...

Post by: fwa, Mar 14, 2006 in forum: SQL Server 2005 General DBA Questions

mmarovic - thanks for the tips. I had hoped to avoid it but am beginning to think that a LOT of the queries will need to be rewritten....

Post by: fwa, Mar 14, 2006 in forum: SQL Server 2005 General DBA Questions

OLD Machine: Windows 2000 Ent. SP4 SQL 2000 Std. Dual 1.8GHz Xeon Procs 4GB RAM Smart Array with single mirrored pair for db & log files NEW...

Thread by: fwa, Mar 14, 2006, 13 replies, in forum: SQL Server 2005 General DBA Questions

I recently restored a SQL 2000 database to my brand new, souped-up SQL 2005 server. Some queries that used to run in under a second in 2000 now...

Thread by: fwa, Jan 26, 2006, 1 replies, in forum: SQL Server 2005 Clustering

Hi, I've got my Win2003 cluster up and running. I've created a new cluster group "SQL Server". What resources do I need to add to it? My main...