To switch or not to switch

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 Stewart Campbell » To switch or not to switch

25 posts, Page 3 of 3

«««1 2 3

To switch or not to switch

Rate Topic

Display Mode

Topic Options

Author

Message

Adi Cohn-120898

Posted Monday, November 15, 2010 9:26 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:47 PM
Points: 2,023, Visits: 4,948

I have to admit that I failed the question and I was surprised. When I saw the correct answer I couldn’t believe it. Every single option that was selected as correct was not correct. I joined the discussion and only then I’ve noticed that the question was about the options that are not correct. In short I found out that maybe I know something about partitioning, but apparently I’m a poor at understanding what I read Smile

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
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 #1020878

Iulian -207023

Posted Friday, November 19, 2010 4:30 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 6:47 AM
Points: 847, Visits: 770

The question is challenging and asks for more attention on details when reading, this is not one of my main strengths.

I read the documentation, was lucky to find here:
http://msdn.microsoft.com/en-us/library/ms191160.aspx

Did anyone used the SWITCH option in production?

Thanks,
Iulian

Post #1023408

Stewart "Arturius" Campbell

Posted Monday, November 22, 2010 12:00 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:46 AM
Points: 3,157, Visits: 4,341

Iulian -207023 (11/19/2010)

Did anyone used the SWITCH option in production?

It is used as part of the archiving of large tables in our data warehouse environment.
Using SWITCH has reduced the population time from approx 36 hours (750+ million records) to add approx 25 million records per month to less that 1 hour (99.9% of that time taken to populate the staging table from which the data is switched into the archive table, the actual switching operation takes on average 10 milliseconds)

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1024155