Rebuild Online Index in Partationed Table

Question

Post reply

Rebuild Online Index in Partationed Table

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

pawana.paul SSCommitted Points: 1686 More actions · Answer 1

Hello Ed,

Looks like this session is to attend inperson. Is it available online by any chance?

Regards,

Ed Wagner SSC Guru Points: 287024 More actions · Answer 2

Not as far as I know.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

pawana.paul SSCommitted Points: 1686 More actions · Answer 3

pawana.paul

SSCommitted

Points: 1686

August 13, 2014 at 2:26 pm

#1737820

Thank you Ed for the info.

Regards,

Pawana Paul

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 4

pawana.paul (8/12/2014)
Thank you so very much Jeff. This info. helps.
Is it possible to share 2 hours lecture you written on this topic? Please send me on pawana.paul@gmail.com, if possible.
Thanks very much for all your help.

I hadn't gotten to the next question. 🙂 Now that we've established you have different filegroups, we need to get a little more specific please. Is there 1 file group per partition and is there 1 file per partition? Also, are those file groups on a different drive than the PRIMARY filegroup?

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1003865 More actions · Answer 5

pawana.paul (8/13/2014)
Hello Ed,
Looks like this session is to attend inperson. Is it available online by any chance?
Regards,

Attending in person would be seriously beneficial, but it's not necessary. I just want to make sure that your problem fits the point of the lecture. Otherwise, it could lead you down the primrose path and you'd waste a whole lot of time trying to do what can't be done.

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

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

pawana.paul SSCommitted Points: 1686 More actions · Answer 6

Hello Jeff,

Here are the details:

Each partationed table have 4 indexes, each index has 16 partations. Each index partation is on one file group (4 partations are sitting on one file group e.g IDX1 have IDX1PART00-IDX2PART15 and IDX2 have IDX2PART00-IDX2PART15, IDX1PART00, IDX2PART00,... are sitting on one filegroup). All are on single LUN.

Regards,