Peter Samson (2/4/2010)

---

My personal rule of thumb has been to never use a table variable if more than 500 rows. This posting by the SQL Server team says never...

Thanks! ...

lmu92 (2/4/2010)

---

Special thanks to the standard purchasing guidelines to have an RFQ process that involves at least 10 suppliers (each one having your contact information) if you need a ball...

Hugo,

I have the greatest respect for your work too - I particularly enjoy your SQLBlog entries, for example, and as I mentioned the set-based iteration method is very impressive.

I think...

Last post for tonight (which is now very much this morning). I read the Connect items with great interest, and voted on all except the trigger one. I...

No - my future consulting daily rates depend on the majority of skilled...

Hugo and Tony,

Let me try to summarise my position on this.

I don't in fact use the quirky update in permanent or routine production. I never have and probably never...

It seems mightily unfair to blame poor Jack for all the data corruption, poor performance and deadlocks in the world!

(Or is that just me deliberately mis-reading Gail's post: "Would you...

Tony, I know you're busy - hey we all are, but I have to say (from a quick scan of your script) that it doesn't seem to feature any of:

1....

tony rogerson (2/4/2010)

---

I've presented a number of times at UK user group meeting on running totals; I have an example that proves the opposite. The cursor was faster -...

At last! :laugh: 😛 😀 :w00t:

And I have it in writing. Even if it did require extreme editing skills.

Paul

tony rogerson (2/4/2010)

---

Cursor is imho the best approach for this because you can put an ORDER BY - you have repeatable results with syntax that is well defined in terms...

Hi Hugo,

You overlooked my post which addressed the 'problem'. It was quite long, so I'm quite shocked that you missed it 😉

Extract: Paul White to Jeff Moden

---

How much do...

Adam Machanic (2/2/2010)

---

Whether or not Dispose is called on SqlChars/SqlBytes seems like an implementation...

Adam Machanic (2/2/2010)

---

Paul White (2/2/2010)

---

...This means that LOB output from a UDA has to be fully built before it can start to stream. Kinda seems to defeat the purpose...