Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

To switch or not to switch Expand / Collapse
Author
Message
Posted Monday, November 15, 2010 9:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 1:28 AM
Points: 2,105, Visits: 5,393
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

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
Posted Friday, November 19, 2010 4:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:33 AM
Points: 904, Visits: 837
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
Posted Monday, November 22, 2010 12:00 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: Today @ 5:47 AM
Points: 3,855, Visits: 4,994
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
Posted Wednesday, November 24, 2010 11:44 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:24 PM
Points: 21,209, Visits: 14,896
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1026097
Posted Wednesday, November 24, 2010 2:45 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:33 AM
Points: 904, Visits: 837
Thanks a lot Stewart, that's a great idea.

Cheers,
Iulian
Post #1026217
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse