[dba-SQLServer] Data Transformation Question

Thanks Arthur,

In this case I suspect it wont matter, however this tidbit of information is good to know and I will file for future reference.

Cheers
Darryl

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Tuesday, 8 July 2008 2:37 AM
To: Discussion concerning MS SQL Server
Subject: Re: [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.
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.