RE -- sql server data mining

SeriousQuakeLoser
1/28/2004 12:44:52 PM

Are you certain that the database files are actually
fragmented. i think SQL has a good way p of preventing
fragmentation for that would seriously slow down the
server.

you could Stop Sql Server, off load the db files onto
another drive. Either through backup and restore or as
flat files. backup and restore is probably best.

Then run W2K defrag analysis again and see if you drive is
still fragmented, if so then defrag. Replace your files,
watch the permissions on the files before and after you
move them, then re-run your analysis. i would suspect

Noah Ganter
2/4/2004 8:23:09 AM

A fragmented harddrive can seriously affect SQL Server performance. In fact,
if a massive INSERT, UPDATE, or DELETE Statment is terminated prematurely,
it can leave the harddisk very fragmented. Run Defrag.

[quoted text, click to view]

sql server data mining : RE