SQL Defrag

Question

SQL Defrag

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Dominique DUCHEMIN Mr or Mrs. 500 Points: 544 More actions · Answer 1

To defrag is it always a manual process for safety reason or other or could we automate the process?

dbuchan SSCrazy Points: 2328 More actions · Answer 2

Dead simple. Note current time. Issue defrag command. On completion note time. Observe difference between recorded times, hey presto !

Or:

No.

The systems fine with no users loggged in. Can we keep it that way ?br>

Jeff Moden SSC Guru Points: 1003894 More actions · Answer 3

Dominique DUCHEMIN (6/11/2008)
To defrag is it always a manual process for safety reason or other or could we automate the process?

Sure... create a scheduled job... you can use SQL Server to do it or Windows Task Scheduler. Or, I'm pretty sure you can include it in a "maintenance" job.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)