Viewing 15 posts - 196 through 210 (of 529 total)
Speak for yourself Remi, another 2 hours for me and i'm off on holiday for a week.
Woo hoo
August 19, 2005 at 8:18 am
You can detach the databases on the smaller drive, move them to the larger partition and then re-attach them without any problems.
Have a look in BOL for sp_detach_db and sp_attach_db...
August 19, 2005 at 5:39 am
I think i'd stick with phill's explanation if I were you.
These are most definately statistics that are automatically generated by SQL (assuming you've got that setting turned on) when...
August 19, 2005 at 5:13 am
and try not to install 'mistress.exe' as that results in all sorts of problems.
How about this one
Breakfast.com halted: Cereal port not responding
August 19, 2005 at 2:28 am
Good question, I did my first SQL 6.5 admin course in a classroom with about 6 months of self study after it before I took the exam. I now tend...
August 18, 2005 at 10:03 am
dbcc shrinkdatabase (<your db name>, 10)
This would shrink the database giving you 10% free space when the job had finished. I still say that you shouldnt bother wasting time shrinking...
August 18, 2005 at 8:50 am
Hi There,
The SP I sent you via PM is only good for shrinking the log file, in order to shrink the Data file you'd need to do something else. ...
August 18, 2005 at 8:33 am
Speaking from my experience, the certification was more of a starting point rather than a goal. Sure it makes you learn the important stuff to pass the exam but 8...
August 18, 2005 at 8:25 am
It's going back a while but I seem to remember seeing this sort of thing if one of the windows event logs was full, can you check and make sure...
August 18, 2005 at 8:04 am
I prefer to go down the virtual PC route myself, keeps everything seperated and lets me break things during testing without having to rebuild the PC from scratch.
August 18, 2005 at 7:58 am
You can always send the contents of DBCC SQLPERF(LOGSPACE) to a temp table and check that the Log Space Used % isn't above a threshold value.
Create Table #TempTable ([Database Name]...
August 18, 2005 at 7:56 am
I don't know about the extra controller but I wonder whether you'd get better performance from combining G and H together, more spindles in the array = better performance.
It's not...
August 17, 2005 at 5:12 am
Viewing 15 posts - 196 through 210 (of 529 total)