Tried re-installing Windows Server SP 2 yesterday after the restore and re-booted the server, still had the same problem, I suppose the extreme would be to stop the server, cut...
I have used this script on a 176GB file (Database & Log file) which reduced to 100MB in approx 20 minutes, after backup. Just remember to put in the name...
Fragmented indexes slow down your SQL Servers and keep your clients waiting, not good for a business. Using DBCC SHOWCONTIG to create your trend analysis is time-consuming and slow. ...