Post reply

DATE AND TIME Datatypes storage

  • July 16, 2010 at 11:30 pm

    #223409

    Hi,

    I have a database from the sql server 2005 and migrated to sql server 2008, in that i have changed the datatype of a columns smalldatetime to date for the column ( Createddate), smalldatetime to time(0) for the column ( CreatedTime).

    how can i know that the table size(storage ) is reduced?

    Please help me out.

    Thanks

    🙂

  • July 17, 2010 at 2:02 am

    #1194481

    Simple answer is, you may have to rebuild the clustered index on this table until then space won't be released. I have some sample code and some DBCC PAGE commands to prove this and not sure without explanation, readers will understand this. I will see what I can do, may be write a blog post later.

    [font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply