Hi Kev,
" Can anyone explain the discrepancy between max_workers_count and the calculation as I presented it here?"
You can set the max number of threads manually (basically not...

Thank you David,
i can only repeat the others; very interesting. I will definitly use this as a good example for uneven configured multiple database files 🙂

Thank you all for your positive feedback.

I love to create QotD with a bit more "substance" from my real world experiences.

I will try to write more of them in the...

Hi,

of course you can test it with a clustered index on one or...

Thank you Carlo for your valued comment. Pleas take into consideration that your example is completely different from the original question. The usage of a variable in a batch will...

Don't worry Koen,

forgiven - you are an expert for BI 🙂

Hi Koen,

NO - TDE is EE only. Extract from the official resource:

Feature | EE | SE | ..

TDE | Yes |...

Hi Steve,

hmm - TDE is not SE but EE.

Parikshit Savjani (MSFT): "TDE is Enterprise edition only"

Steve,

I answered all three options correct:

- text/ntext

- XML

- CLR datatypes

but the answer is marked as wrong. In your given solution you mention exactly the same options.

Can you check it?

Best from...

Hi Folks,

There is a mistake in the correct answers. I have informed Steve to fix it.

Correct answers must be:

- the NON UNIQUE Index stats will be updaten

- the UNIQUE Index...

Hallo Hugo,

thank you for this - EXCELLENT - explanation. To be honest; i wasn't at any time so deep into this operator and I really appreciate this deep and detailed...

sknox (8/7/2015)

---

Here's a thought... If this is a table which needs to support a large number of concurrent writes as quickly as possible, why was one option not a memory-optimized...

Luis Cazares (8/6/2015)If identity is ever increasing, how can it create the same fragmentation of a random value?[/Quote]

Hi,

fragmentation on an identity value can surely occur if you have a high...

Hallo Wayne,

your measures are not correct because you didn't run the process:

- for each table separately

- with 200 concurrent Connections

Than you will have a HIGH fragmentation on the IDENTITY table...