it should install side by side, or you can just leave people with the 2005 version since it's backwards compatible

i'll take 1 db per client over 1 db to rule them all any day

if you move everything into 1 db you have to keep track of which table belongs...

i thought only the index key was created and the data wasn't physically reorganized

what about running checkdb with allow data loss?

around 6 months back we had corruption and I think that's what fixed it. checktable didn't pick anything up

i was never brave enough to restore from SQLEM or Management Studio. I either do it via Veritas or when it's a .bak file i always do it from script

yes you can do it, but i don't know if the license says you have to physically remove the CPU's from the server

if you have IO issues cheapest way to fix them is to add new drives and split the database

add multiple RAID1 volumes and break up the db files and make...

i set it up to execute sql for an alter table task

i change the smalldatetime to varchar(8) before the import then change the column back to smalldatetime after all the...

any idea what kind of performance hit you are going to take with the triggers? where i work every time someone asks for a trigger there is big conference at...

if you are interested in C++ then check out a college text book

you can download Visual Studio 2005 Express for free from msdn. it includes C++, C# and other languages....

bad idea

SQL likes to grab all the resources that it can, and if you run it on a VM it has to compete with other VM's

We just bought into VMWare...

we upgraded another server in our environment, and that was a side by side. It went pretty smooth. For now things are on hold, but we will probably try to...

nice scary advertising

any upgrade should first be tested in a QA environment to find any problems. Then upgrade the least used SQL server in your environment to catch any other...

someone else was doing it and not sure what went wrong. but we even ended up uninstalling sql2005 and reinstalling it from scratch. Replication still didn't work, but with our...

if you want sql2000 and 2005 on the same box you will need a named instance

easiest upgrade is to buy new hardware, install, configure and then rename the server