Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: In-Place Upgrade or Migration

    I've done a few in-place migrations on some virtual machines. Its a lot simpler if the upgrade isn't too big and the OS is aceptable. And the VM snapshot simplifies...

  • RE: Securing Your Instances

    I suggest that installig as a named instance (compared to the default instance) does much of this automatically. And if within a network the port is randomised each SQL restart....

  • RE: Disk Defrag Tools on SQL Server system

    Hi Folks,

    SysInternals (Microsoft) has a tool called contig. Contig uses the inbuilt windows filesystem defrag engine, and can specify a drive, a folder, or individual files. And yes it is...

  • RE: rebuild index using enterprise manager

    Hi,

     

    From query analyser you can do this:

    execute sp_msforeachtable 'dbcc dbreindex( [?] )'

    You can schedule this as a job by entering this as the query in the job-step.

     

    Or you can achive...

Viewing 4 posts - 1 through 4 (of 4 total)