that is a good question and one i've sent around to the developers 🙂

EDIT: of course they do 🙁 ... haha ... ok that sucks, anyone know an alternative to...

Hey Michael, both query plans are the same (see image).

To be clear, I don't generate the SPs on the fly. I generate them (manually) before starting my test. I've...

MadAdmin (1/12/2016)

---

Stijn Vervaet (1/11/2016)

---

I want to try the Dynamic SQL generation, but something tells me that (especially since some of my tables have a LOT of columns, since this...

Apologies Michael, I was trying to get my DSQL-SPs generator to work so I could test it and forgot to provide you with the execution plans. I will provide you...

Thanks all who contributed.

I did continue altering my SP-generator (I don't want to create a SP by hand for each table in the database), this now generates the following...

Hello gentlemen,

I investigated the “SP with Dynamic SQL” for a couple of hours this morning and came to the conclusion to move away from this route in the end....

Hi Eric, thank you for weighing in. As I have multiple application servers running similar type transactions against one database server, there is definitely a lot of concurrency.

I do...

Thank you Michael for your thoughts. As a sole DBA it's sometimes hard to come up wit a good solution without somebody to spar ideas back and forth with.

-...

Hi Sir, talk about quick turnaround. I was actually already editing my post, please allow me to give some more details:

Can you further define "big transaction"?

==> 500 to a...

Thanks ... i'll see how it goes when i up the backup frequency when i'm reindexing.

Much appreciated,

Stijn

Hi,

I am using a similar approach (running a SHOWCONTIG and use the output to decide which indexes need to be defragmented). However, i am always running into rapid growing...

As a matter of fact Microsoft DID already react and is now planning a world wide TV event in collabo with MTV to showcase their new product days before the...

I believe a complete calculation method and reference to the size of every datatype can be found in BOL. 'estimating table size' ... good luck!

Stijn