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

Partition SWITCH Expand / Collapse
Author
Message
Posted Wednesday, September 9, 2009 12:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801
Comments posted to this topic are about the item Partition SWITCH
Post #784718
Posted Wednesday, September 9, 2009 6:57 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660, Visits: 558
Nngh.. "Select ALL that apply".

Must. Read. Question. Properly.

Thanks for the question bythe way!


--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams
Post #784872
Posted Thursday, September 17, 2009 6:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 10:20 AM
Points: 558, Visits: 1,471
Good question but IMO should have specified switch DATA from table to already partitioned table and DATA from partitioned table to unpartitioned table. I know it's pendantic but I've lost points on pedantic questions in the past.
Post #789596
Posted Friday, September 18, 2009 2:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Nice one, Haven't actually worked or used partitioned tables myself and I want to start with the implementing as I have a table that could be done, but I am wondering if this could be done for a table that needs to be accessed by a cube...

Busy doing my homework and I guess I shud have something when done.


What you don't know won't hurt you but what you know will make you plan to know better
Post #790166
Posted Friday, September 18, 2009 2:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Nice one as I am yet to implement partition tables. Busy with my homework and should have better knowledge after some implementations on m test db

What you don't know won't hurt you but what you know will make you plan to know better
Post #790169
Posted Friday, September 18, 2009 2:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
Nice one, lemme do my homework with there as I have never worked with.

What you don't know won't hurt you but what you know will make you plan to know better
Post #790173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse