Partition 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 D Phillips » Partition SWITCH

Partition SWITCH

Rate Topic

Display Mode

Topic Options

Author

Message

DPhillips-731960

Posted Wednesday, September 09, 2009 12:09 AM

Ten 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

Rob Goddard

Posted Wednesday, September 09, 2009 6:57 AM

SSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 3:48 AM
Points: 660, Visits: 557

Nngh.. "Select ALL that apply".

Must. Read. Question. Properly.

Thanks for the question bythe way! Smile

--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams

Post #784872

Chris Houghton

Posted Thursday, September 17, 2009 6:53 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:12 AM
Points: 557, Visits: 1,356

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

Post #789596

BudaCli

Posted Friday, September 18, 2009 2:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

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

BudaCli

Posted Friday, September 18, 2009 2:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

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

BudaCli

Posted Friday, September 18, 2009 2:34 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

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 »

Permissions