RE: Indexes Fragment Really Quickly

SSC Guru

Points: 1003863

May 6, 2015 at 8:23 pm

I figured as much. Vendors aren't so helpful.

Can we narrow down the type of performance problem that you're experiencing? For example, are the performance issues on SELECTs, INSERTs, UPDATEs, or DELETEs? Are they for singleton rows or batches of rows? Is it through a GUI or something else that you're noticing the performance issue? Have you been able to narrow it down to a piece of code and, if so, could you post it along with an actual execution plan?

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