Viewing 4 posts - 1 through 4 (of 4 total)
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...
February 28, 2017 at 10:35 am
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....
January 13, 2017 at 1:11 am
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...
May 21, 2012 at 12:05 am
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...
January 26, 2005 at 10:35 pm
Viewing 4 posts - 1 through 4 (of 4 total)