If you do it in steps and delete the old rows as you go, remember this won't decrease the DB's size on the file system before you shrink your...
The task manager will show 2 graphs in CPU history on the performance tab. Note: will also show 2 if you have a dual CPU machine or a dual core CPU....
Thx for your replies, but none will work. FrankKalis >> The script you provide grant's login to windows users, but you cannot set the default...
After spending more then a day surfing for answers and not finding anything, I'm gonna write here for a solution. If one exists. Is there a way to...
well, as always Joe is right!!! yawn <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Did the below tests with blocks ranging...
You can use the profiler to capture Errors and Warnings, wont put them in the errorlog though.
"Twan" I don't have the skills to interpret the results you have, but you do mean RAID 1+0 and not RIAD 0+1 I presume...? RAID 0+1 offers too little...
Got some new server hardware, and trying to determine the best suitable raid configuraion for our data disk. Im meassuring with sqlio, and see some...
You might wan't to try changing the compatibility level of your new database, i did'nt have the same error but had some other strange diagram error...
Reason to stick with the old ones, you won't have to convert your database when moving it. Specially if you have procedures that uses temporary...
We're thinking about using log shipping from our production database to our development server, which will give us a second (read_only) copy of our...
[HARDWARE] HP Proliant DL385 2x Opteron 275 (2.2GHz dual core) 8GB PC3200 HP Smart Array P600 controller; 2ch 256MB Cache; 75/25 Read/Write Windows...
Thanks for taking the time guys!!! >>Did you take a look of execution plan, with sp? Yes, the actual execution plan of the sp does not have...
Hi, Im having a complicated which is using parallelism when i run it in qyery analyzer, but when i put the statements into a stored procedure it...
Thanks for the advise to everyone, it is greatly appreciated. I will try the advise Joe gave as it makes sense. array 1 : 2 disks, raid 1 Part 1:...
Thank you for your reply, and sorry about the wrong forum. So none has tried having sql server data on their windows partition, or prossibly tried a...
Before long my company will upgrade our existing sql server hardware platform, and i need some advise and thoughts on how to partition disk and set...
Hi, When marking tables as pintable, all the docs i read warns about marking too large tables as pintable, as this will take up all the buffer cache...
Separate names with a comma.
