Adam Machanic (2/2/2010)

---

Always?? I have methods that do this that don't throw exceptions; are...

Adam Machanic (2/2/2010)

---

Really? I'm surprised to hear...

Probably just as well since it is undocumented 😉

I think I used it once to demonstrate lock hash collisions (two...

:laugh: :w00t:

The Dixie Flatline (2/3/2010)

---

Thanks to you as well, Emperor Paulpatine. I'm not surprised that the ITVFs are faster than the scalar functions, but I am surprised by the percentage...

Also https://connect.microsoft.com/SQLServer/feedback/details/496271/row-number-does-not-number-properly-intermideate-cte-result-set

Hi Adam, and thanks so much for taking the time to reply so fully! I have looked at the connect items you listed (as you saw) but am struggling...

The Dixie Flatline (2/2/2010)

---

Curiousity question. Have you seen any documentation about the performance of scalar functions which do NOT do data access compared to inline table valued...

Ok - I'll bite: What was the #1 funniest thing on SSC tonight?

Difficult to say. It would probably depend on the exact...

The Dixie Flatline (2/2/2010)

---

I assume you are talking about data access within scalar functions, not inline table-valued functions. Data access through ITVF's can be ruthlessly efficient...

TheSQLGuru (2/2/2010)

---

Something tickled the back of my mind on this one that there was an important reason for giving the engine some breathing room between the min and max settings....

Depends on the type of function, but a common error is to do data access inside a scalar function (for example). The idea sounds reasonable until you realise that...

sgmunson (2/2/2010)

---

CLR is prohibited on the server in question, but even so, I'm not entirely sure that's true, as each iteration further limits the record selection until finally there aren't...

GilaMonster (2/2/2010)

---

I'm fast losing both patience and hope. The last month, it feels like I've been correcting almost as many replies as I have been answering questions

http://www.sqlservercentral.com/Forums/Topic856902-145-1.aspx#bm857286

http://www.sqlservercentral.com/Forums/Topic475163-146-1.aspx#bm856344

http://www.sqlservercentral.com/Forums/Topic855771-360-1.aspx#bm855992

Am I getting too...