DATE AND TIME Datatypes storage

  • 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

    🙂

  • 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