One of the main benefits of a SAN is that if you have homogeneous hardware servers, you can use free Xen to employ hot-failover for Virtual Machines. I've seen...

This just smacks of laziness on the developers part, to go to google and look up the API of their language's SQL Data Reader object. Pretty much every DB...

(Also @GrassHopper )

I agree, but...

We have to do something very similar, and I like some aspects of the OP's approach, but I'd like to share some experience, having done it daily for the last...

That's a gem that's probably well hidden in the documentation. Thanks for pointing that out! Although for really small reference tables (which the OP was saying he...

Using XML to make a CSV in this way is like cracking a nut with a death star.

Thanks for this, I could have done with your nice scripting bits the other day, when we discovered one of our clients had installed their warm standby server with the...

We have a number of servers which often run into tight-memory situations, we've tried the above approach quite exhaustively. The frequent creation and destruction of temporary tables...

RBarryYoung (6/25/2010)

---

Thomas-282729 (6/25/2010)

---

Nick Walton (6/25/2010)

---

I'm really looking forward to this series, as there's been a higher than average number of "Cursors are baaaaaad" posts on SSC recently. Your...

Thomas-282729 (6/25/2010)

---

DBA: A. Why is it my problem that someone else did not do a better job of planning ahead? B. why are you pulling one record at a time...

Thomas-282729 (6/25/2010)

---

There is an answer, but you probably won't like it: don't do it in a stored procedure.

If you cannot accomplish a given piece of work in a set-based...

At 35 pages by 10am GMT, I think that qualifies as Understatement Of...

I'm really looking forward to this series, as there's been a higher than average number of "Cursors are baaaaaad" posts on SSC recently. Your article seems to indicate...

Having read through umpteen threads on here like this, I think that every article on SSC should have a disclaimer:

"All concepts, views, and results in this Article are as...

If I can add another more physical perspective to this, I'm afraid that I've found that the temp variable solution can be *vastly* slower than cursors. The time...