Table Partitioning - Again

I wrote some time back about changing the identity property of an existing table.
http://preethiviraj.blogspot.com/2007/09/table-partitioning.html

The author of Inside SQL Server, Kalen Delaney wrote about it recently. As I used to read her blogs, I wrote a reply to that.
http://sqlblog.com/blogs/kalen_delaney/archive/2007/07/13/did-you-know-it-s-in-the-books-online.aspx

Interestingly, my friend and co worker Jude Pieries too wrote about the same feature in his article
http://sqlserveruniverse.com/content/DEVL0400101022007SwitchingFromNonIDENTITY.aspx


PLEASE HAVE A LOOK!

Table Partitioning

I was asked to speak at the Sri Lankan SQL Server User group Meeting on Table Partitioning.
I did it last week (August 16 2007) and as usual I took another 15 minutes from the next speaker too.

The slides and example are available at
http://sqlserveruniverse.com/files/folders/meeting05/entry301.aspx
http://sqlserveruniverse.com/files/folders/meeting05/entry302.aspx

Interestingly, I found a method to change (Cerate/drop) the identity property of a column during my preparation for this presentation. I was told by many members that they were forced to add a column and drop a column to the table just because they wanted to have the identity property added or dropped.

Is it Interesting? Check out at the examples