Great article.

We're starting to use JSON more and more so I can image I want to use code like this in the near future.

I made a little change to the last script to also include the where clause of a filtered index. I also removed the collate because this didn't work for me.

--1....

The snapshot isolation level didn't work for the foreign key blocking. But we are still going to do some tests with it for the several other blocking situations on which...

I'm trying to set the snapshot isolation level, but unfortunately this takes some time 🙁

So in the meanwhile I googled it and found that someone else says it won't help:

I’m...

Have you tried changing the order of the clustered index. You say you did try this index:

(IntDate ASC, CustomerID ASC, PartitionID ASC) ON[PartitionedTables](PartitionID)

But have you tried putting the PartitionID fist?...

yes 😉

Paul White (2/22/2010)

---

So, the worktable was either an index spool or lazy spool caused by the lack of a useful index. The post containing the execution plan did mention...

RBarryYoung (2/22/2010)

---

Sander A. (2/22/2010)

---

RBarryYoung (2/22/2010)

---

And now, having said all this and gone all this way, I notice something that could make it all irrelevant. *sigh*

Sander: you said...

RBarryYoung (2/22/2010)

---

And now, having said all this and gone all this way, I notice something that could make it all irrelevant. *sigh*

Sander: you said that the slower...

[quote-0My honest recommendation is that you seek the services of a good consultant at some stage to help you.

[/quote-0]

There is a big change we will do that in the near...

Oke, i will post the queries and the statistic output, maybe you can tell me something more about it. As you can see the query cost of the first query...

A named check doesn't have the same advanteges for the plan-compiler as the NOT NULL has (i believe). I just want the tables to be 100% correct, if i have...

The ordinal position isn't an issue, those aren't in the right order anyway.

But how can i add a column which is NOT NULL while it is empty. Than it would...

There were indexes on them, but i had to drop them before...

There is 600gb free space for the log to (auto)grow and the recovery mode is already simple. But this still isn't enough.

I'm currently working on a script of creating a...