Our Prod SQL 2005 server is experiencing timeouts and error establishing connection errors. This is happening ever since more people are using the...
I am not able to get my DB Trace analyzed through the Tuning Advisor. Here is what I am doing ... I create a new trace. Capture activities for 30...
I would like to setup SQL 2005 clustering. I am not sure what all I need to have ... I have a Windows 2003 Enterprise Server with multiple VM's on...
Is it possible to set-up a SQL Cluster on a Virtual Machine running Windows 2003 just for testing purpose and playing with Cluster installation?...
I would like to move a SQL 2000 DB to SQL 2005 Enterprise Edition. My SQL 2000 DB already has a few users in it. When I do a full-backup in 2000...
I have a table which has about 80,000 records. Table has a composite key of quest_id, quest_country and quest_year. When I run a delete statement:...
Hi, I have gone through the forum and read a few posts on this issue. I am still having the problem: My DB is about 600 MB and Log is about 2GB. I...
Sometimes, the server on which my DB resides starts slowing down. At that point, the CPU is at constant 100%. After a while (usually 2-4 hours...
Hi, We have a User table that contains close to 10 million rows of data. We expect it to grow by atleast a million rows per month. For each user,...
Separate names with a comma.
