IgorMi (12/10/2013)

---

Here I think it's good to remind you...

GilaMonster (12/10/2013)

---

Free space in the data file should...

planning to leave about 10% free space so...

thanks, that was my assumption.

Kurt W. Zimmerman (12/9/2013)

---

What are you doing to manage the transaction log? If your database is in Full recovery mode you should have a job that performs a transaction...

any lists available for those types of changes? just curious.

aha. i didn't know that about vendor support conditions like that. we will verify this with the vendor as to not violate any support terms.

but in theory, the behaviour...

if it were anything else other than SAP i would pursue it. it's not worth the uphill battle and i'm def not doing it covertly. there's actually no perf problems...

oh man, the ola scripts are slick. 🙂

thanks. unfortunately its SAP so i can't change anything. it would be super cool if MS would make a more intelligent reindex/reorg task that could skip indexes with allow page...

is it a 24/7 avail db? Then you'll have to pay for Enterprise Edition for the ONLINE = ON option. If not, can you do if off-hours? I do mine...

i just want to bump this old thread for future reference and to give props to the people who have posted here. very interesting and excellent information on the subject....

Thanks, Grant. After thinking about it more last night, I realize that it would have to be something like that using profiler to intercept all the calls to the database....

120% is a better figure. 😉 i've always known the space needed as 120% the size of the index (for user db space, wasn't clear on tempdb) but seems even...

TheSQLGuru (6/19/2012)

---

The official guidance is to be found in the document here, Table 2. It is basically size-of-index-plus-a-bit operation for the sort, no matter if it is in the...