What would...

Unless a table lock is taken (and/or specified).

David Benoit (5/22/2012)

---

I think the issue here though Paul is that you just stuck a language into the database realm where the people that support it had no knowledge of...

Jeff Moden (5/22/2012)

---

Then I had idiots write things like a modulo function and a merge in CLR because they didn't know how to do it in SQL and saw a...

peter-757102 (5/22/2012)

---

The new licensing model for SQL Server 2012 model isn't very encouraging to the company I work for to make a switch to this version. But we did made...

Usman Butt (5/22/2012)

---

SQL Kiwi (5/22/2012)

---

Usman Butt (5/22/2012)

---

Sadly, it is one of the shops where CLR is not permissible 🙁 Otherwise, for sure, I would have chosen your CLR without any...

peter-757102 (5/22/2012)

---

http://sqlblog.com/blogs/paul_white/archive/2012/05/03/parallel-row-goals-gone-rogue.aspx

You are familiar with your own blog i presume 😉

In my view, what you shown us there is a bug (in the...

That is sad....

TheSQLGuru (5/22/2012)

---

As always you have a great breakdown of what is going on in the plan Paul! To the OP: Paul makes a great point about helping the optimizer...

peter-757102 (5/22/2012)

---

As for bad performance with some implementations, please try to bench with option( maxdop 1) too as there exists a bug in SQL Server 2008 and later that...

Usman Butt (5/22/2012)

---

Since, in the future, we may need the VARCHAR(MAX) version as well, I did some testing on the other solutions as tally table solution is a sore loser...

Sergiy (5/21/2012)

---

The "original challenge" is not accessible. May be temporarily.

But anyway, both articles focus on splitting the load on the SINGLE index (heap in "Boosting INSERT" case). In "Resolving PAGELATCH...

Elizabeth.Block (5/21/2012)

---

Two questions - could the differences between the estimated and actual number of rows be due to bad statistics? I know the statistics at one point were very...

Dumb.

It seems the original coder misunderstood how ORDER BY works with UNIONs. Anyway, I might go a little further (apologies for things that are just my own personal style,...