Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Solomon Rutzky » Restructure 100 Million Row (or more) Tables...

34 posts, Page 4 of 4

«««1 2 3 4

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Friday, October 05, 2012 7:52 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1369360

Cliff Jones

Posted Monday, October 08, 2012 9:55 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:56 PM
Points: 3,400, Visits: 3,411

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

Luke C

Posted Tuesday, October 09, 2012 1:16 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 17, 2013 6:14 AM
Points: 238, Visits: 900

Solomon, here's the article I wrote that similar but instead uses change tracking. [url=http://www.sqlservercentral.com/articles/Change+Tracking/74397/][/url]

Luke C
MCP, MCTS, MCITP - Database Administrator & Database Developer

Post #1370549

Neha05

Posted Tuesday, December 25, 2012 8:27 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55

Great article.

Post #1400066

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions