I almost got thrown off by the "SQL Server 2008 R2" part, thinking maybe this had changed since 2005. 😀

Nice straightforward question!

Rich

Ninja's_RGR'us (12/9/2011)

---

Ninja's_RGR'us (12/9/2011)

---

rmechaber (12/9/2011)

---

Someone correct me if I'm wrong: columns that are part of the index definition can be used to filter a query based on the WHERE clause. ...

GilaMonster (12/9/2011)

---

rmechaber (12/9/2011)

---

they can be returned with a query (eliminating the need for a bookmark lookup, if all the columns requested are included; i.e., the index is "covering" for the...

Someone correct me if I'm wrong: columns that are part of the index definition can be used to filter a query based on the WHERE clause. Columns that are...

Thanks for the kind reply and apology Jeff, I appreciate it.

I'm glad I took the time earlier to explain why I didn't think I'd misappropriated or misrepresented your...

I'm a little late to this question, but here's my chicken-#$%^ way I deal with things like this when the OPENROWSET target is small: I read everything in to a...

Good question, got it wrong, learned something today about time rounding. Well, re-learned.....:ermm:

Rich

Edward-445599 (11/3/2011)

---

I have recently seen a few T-SQL queries starting with “WITH” I understanding what’s happening I am just surprised and a little embarrassed I haven’t seen this before, I...

That's great, I'm gonna add that word to my list! 😀

Rich

Thanks for an informative article Perry, but I'm left wondering what the benefit is to creating/using mount points is. For containing SQL system files, they seem like just another way...

Stopped reading the linked story once I got to this gem:

Another candidate [for most expensive mistake] could be IBM's choice of Bill Gates over Gary Kildall to supply the operating...

sleipner (10/20/2011)

---

rmechaber - thanks, I'll give SSRS a try. I use Excel often as a cross-check on the results, copy the data over then use pivots to validate results....

I don't know of a way to do this, but if you have an already-created trace on the server, you can start/stop the trace with sp_trace_setstatus and load the trace...

sleipner (10/19/2011)

---

I haven't really used SSRS (we just upgraded from SQL Server 2000 and didn't have it before) - is it possible to create a generic wrapper report that will...

Jeff, if you were anyone else I'd just shrug off your emphatic reply as overreaction and leave it at that.

You have been a great help to me and literally thousands...