thanks

I love this forum.

If it is not indiscrete, I would like to know about the changes (tweak) that you made...

It seems that something in the code was a dead give-away (almost) for parameter sniffing.

Care to elaborate a bit on what was the red flag ?

Jeff Moden (7/5/2010)

---

... In the meantime, here's a simple cursor that reads a couple of values from a table and displays them. If you're in the GRID mode, it...

" I might cut down the size of the rows to 200kb"

I guess you meant 200 bytes, not kb (just to show off, I did pay attention :-).

And now the...

Steve Jones - Editor (6/8/2010)

---

think widely. I have had cases where we do store data in a table that is relevant to that entity, but is rarely queried. Keeping it...

Steve Jones - Editor (6/3/2010)

---

I have done separation like this, vertical partitioning for some data. I don't see an issue with it, and like Jeffrey, I wouldn't add an identity...

Jeff Moden (6/1/2010)

---

j-1064772 (6/1/2010)

---

Paul White NZ (5/5/2010)

---

Jeff Moden (5/5/2010)

---

Doesn't this remind you of the 'triangular join' I surprised you with a few weeks back? The one with the computed...

Paul White NZ (5/5/2010)

---

Jeff Moden (5/5/2010)

---

Doesn't this remind you of the 'triangular join' I surprised you with a few weeks back? The one with the computed column CASE expression...

Yeah....

Jeff Moden (7/21/2009)

---

Heh... ROW_NUMBER from SQL Server 2005+ would certainly make this easy. But, this is 2k so we have to go back to brute force every once in...

Posting the code and the table creation and populating scripts enables us to execute the code to see what is wrong. By withholding the above, you force the forum members...

All CAPS for keywoards is how started learning T-SQL.

It is also used in Books-On-Line.

The one advantage I can see is when in-line SQL code is embeded in C# or Delphi,...

Abslolutely ridiculous example.

Bad advice.

This is the most inefficient way of calculating factorials.

At least if there was a warning that this is intended to show how recursion works along with a...