[dba-SQLServer] Data Transformation Question

One thing that you should know about TRUNCATE is that it does not return the
space to the OS. In many cases that's no big deal, but if you're trying to
recover disk space then look into DBCC SHRINKFILE.

Arthur

On 7/7/08, Darryl Collins <Darryl.Collins at coles.com.au> wrote:
>
>
>
> hmmm... speaking of dumb...  I do a bit more research into this (outside of
> SQL help) and found it why it works, why it is different from delete and
> tested it a few times in a sproc.
>
> So far so good.  Although I am suprised that I still cannot find it in MS
> help.
>
> cheers
>
> Darryl.
>