Given a procedural method, couldn't a CLR UDA be made to work quite nicely? If so, I'd...

TheSQLGuru (2/2/2010)

---

Thanks for the Myth Busting there, although I will point out the obvious in that you get the 'right' plan with temp tables without the need for the OPTION...

It does indeed depend - but on the other hand more RAM never hurt a system 🙂

Oh it is -...

Odd question to be asked, but that's the answer:

The Profiler event is Attention - you'll find it in the Errors and Warnings event group.

There is no query - it's a...

Matt Miller (#4) (2/1/2010)

---

Agreed to avoiding @@identity- although if you...

When you hit 'cancel query' or 'stop' in SSMS, it sends an out-of-band data packet which is recognized as an Attention by the server. You can see Attention events...

Isn't this just a simple paging problem - return page 'n' from a set of ordered results?

Hard to tell without a clearer explanation, sample data, and expected output, as Lynn...

SQL Guy-482125 (1/15/2010)

---

Recently I was asked at interview what is the difference in terms of performace between sub-queries, like ...where in (sub-query), and a correlated subquery like ...where exists...

To make sure you improve the thing that will provide most benefit, base your enquiries on This Microsoft Best Practices Article. This is the Waits and Queues methodology -...

Peter Brinkhaus (2/2/2010)

---

Paul, nice solution! However, the first day of the month is missing. Either subtract 1 from DayOffset.n as the parameter for the dateadd function or use a zero-based...

The myth about the Optimzer always treating table variables as if they have one row...!!! :w00t:

So ok yes, if you ask for an 'estimated' plan from SSMS you'll see...

What do you mean by this? In what sense have you allocated 15GB to Windows? Is this a VM?

kakapuri.naveen...

TheSQLGuru (2/2/2010)

---

Jeffrey Williams-493691 (1/29/2010)

---

You should not set the min memory equal to the max memory. This prevents SQL Server from managing memory correctly and can cause some problems (as...

BSavoie (2/1/2010)

---

With EXCEPT, do all the columns have to match to be excluded? The EXCEPT names all the same columns as the select. I guess I would expect to only...