The author should have included that reference in the explanation instead of guessing at how parsing works (and getting it wrong).

Yep.

The main issue is the cardinality estimation for the Filter in the MERGE plan: estimated rows 32 million, actual 10 thousand.

The sorts in the plan require a memory grant, which...

This is a variation of the 'Top N per Group' problem, and there are many ways to express it in T-SQL. Whichever you choose, be sure to make the ORDER...

Scanning the nonclustered index, there is an implied first key on the partition ID, so the following can use a Stream Aggregate:

SELECT sessionid, username

FROM dbo.AttemptedLogin

WHERE sessionid IS NOT...

Don't mind admitting I fell for this completely.

Well done, Steve! :laugh:

NBSteve (3/22/2013)

---

Paul White (2/26/2011)

---

It is possible to avoid the dummy column, ever-growing number of rows in the hidden tables, and avoid locking issues by using an approach based on this...

The only possible reason is so you can say your indexes are SeXI.

Stefan Krzywicki (2/27/2013)

---

I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link...

We can no longer be friends :laugh:

Oi!

That's fine, I'm not posting to prove you...

Lynn Pettis (2/22/2013)

---

As to ordering by a uniqueidentifier, it sorts in ascending or descending order as if it is converted to a CHAR(36) value, or at least that is my...

_simon_ (2/20/2013)

---

Well the point is, that my application is under frequend audits by our client and the random number generator is an important part of it (i am creating lottery...

The batch...