are you doing a lot of updates in your db or a lot of deletes combined with inserting new data? theoretically this can cause the log to be twice as...

i always remove sql 2005 first then the rest of the components like SNAC, BOL and whatever. it's like 5 uninstalls.

i don't think they have the standard edition since it's easier to have one so people can test all the features. and they want to push EE for the $$$

did it many times via the control panel add/remove programs

too lazy to link, but i search the KB. i think there is a .sql file from SP4 you have to rerun on your sql 2000 server

i haven't seen any braindumps floating around, but i've seen different study guides and it's nothing too difficult. like every MS test you have to take the time to study...

which SAN did you have in mind. we are playing with HP DL 380 G5 servers that have PCI express and 3gb I/O paths and they are fast. A SAN...

no can do

if you want 64 bit you need 64 bit hardware, OS and SQL. supposedly you can move db's between 32 and 64 bit SQL. but there is no...

SSIS has this annoying habit where if you create it on your PC and save it on a server it won't work. you have to open the package on the...

too lazy to look, but there is a table in MSDB with the column that says if the backup succeeded or failed

you can do a full backup more frequently so the tran log backups would only be after the last full. can you do a daily full?

test for you implementation. i'm also going to try to test using RAID5 for the db volume to see if there is any performance difference. seems like a lot of...

http://www.microsoft.com

anyone get the KB error when upgrading to SP1? I think there is a link between this error and the KB upgrade error where you ignore the error because the...

did you have good luck with DTA? i've only used it a few times, but found it completely useless in each case and getting dirty with testing much more useful