I have AUTOGROW and AUTOSHRINK db settings on . can anybody confirm how often AUTOSHRINK will run, Ive read that SQL will run SHRINK evrey 30 mins or so. I have had sql trace running since morning and no shrinks have take place on the DB although there is 1708MB still available.
If some one could shed some light on this I would appreciate it.
>Is there any case where we would need to shrink the data file manually?
there can be reasons to do so.
for example, you have moved a big table /index from a filegroup to another. hence, the old filegroup/files
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.