Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY! Expand / Collapse
Posted Friday, October 5, 2012 7:52 PM



Group: General Forum Members
Last Login: Today @ 3:29 PM
Points: 42,079, Visits: 39,468
Gosh... another great article, Solomon. As with anything else, planning and having the resources available for parallel table existance is important but this article covers a problem that a whole lot of people have had even on just SSC. Instead of explaining the whole gambit in the future, I'm just going to point them to this article if they have the extra disk space. Very well done.

As a side bar, I agree with you about triggers in general but especially on the type of triggers needed to pull off this bit SQL prestidigitation. If they are well written and supported by correct indexing, they don't add much in the line of overhead at all.

Again, my hat's off to you for this great article.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1369360
Posted Monday, October 8, 2012 9:55 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
Solomon Rutzky (10/5/2012)[hr
... and now in SQL Server 2012 you can add a NOT NULL field with a default without locking the table ...

That is a nice little tidbit of information that I had missed in the SQL 2012 documentation. Thanks for pointing that out, that will be helpful.
Post #1369915
Posted Tuesday, October 9, 2012 1:16 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 23, 2016 8:53 PM
Points: 239, Visits: 1,134
Solomon, here's the article I wrote that similar but instead uses change tracking. [url=][/url]

Luke C
MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer
Post #1370549
Posted Tuesday, December 25, 2012 8:27 AM


Group: General Forum Members
Last Login: Tuesday, June 16, 2015 2:34 AM
Points: 424, Visits: 60
Great article.
Post #1400066
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse