Post reply

Alter table add identity column with (online=on)

  • January 27, 2022 at 6:18 pm

    #3978011

    Using 2017 enterprise edition.  I'm guessing that adding an identity column to a table with online=on is NOT supported, but want to confirm with the experts.

    It's a big table.  If it's not supported, then I'll create a new table, insert records, drop/rename, etc.

    Thanks.

  • January 27, 2022 at 6:38 pm

    #3978024

    I would think it would be.  Why not try it with a small table and see?

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • January 27, 2022 at 7:02 pm

    #3978029

    The difference between Developer Edition and Enterprise Edition is basically limited to licensing and what words display with SELECT @@VERSION. Anything you can do with Developer Edition will work in Enterprise; they are the same bits. Most of us that would answer your question would start by writing a little code on our local Developer Edition instances.

    You can test your code on a small DB on your desktop, then scale it up to look at perf metrics, long before you go to prod.

    Eddie Wuerch
    MCM: SQL

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

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