FYI - the OUTPUT clause is available in sql2k5 as well.

-a

Thanks much for making it easy on me; all I have to do each 4/1 is send my coworkers a link to whatever prank you have written up. 🙂

Lock escalation is not your problem. If you are the only user, then lock escalation is certainly improving your query. Why pay the cost for lock management overhead when there...

We have a very similar set of dynamic sproc creation sprocs at my work. I find them useful in a general sense but (1) hard to look at and (2)...

SQL Server has ambitions to match this ability with its new snapshot isolation level. When enabled, SQL Server will maintain in tempdb a time-stamped "version store" of all data changes....

If your trim job has any significant number of rows in it, it is generally advisable to expire the rows in batches of N rows. One very easy way to...

JRodman (2/4/2009)

---

I wish it was as simple as that. I cant remember the last time I was able to use a column in a table to sequentially order results. In...

JRodman (2/4/2009)

---

I dont see how it can. You have to have something to return in the first variable to use as the beginning of your range, and unless its already...

dray (1/22/2009)

---

In the video example, wouldn't the same 20 people be selected, just returned in a different order? If you had a table with all the names, you would...

Ordering by newid() is pretty lackluster in the performance department, I assumed this article would cover some great new ways to randomize data 🙁

I've gotten by in a variety of...

I prefer keeping the notion of paging in the client space, in my opinion it is a cleaner API to use something like System.IO.StreamReader and provide input params defining the...

celticfire63 (10/17/2008)

---

The good thing - and I would strongly encourage this - is that over the years, I have tried NOT to over specialize in any aspect of database work,...

I have designed a few tables that we expected to be very actively inserted/deleted against and grow as the business grows. In these cases I created each table on it's...

I have been using the same approach for my sql2k5 standard boxes with great success. I have found that I routinely want to know if a view is (1) an...

Note that there are a few characters that are not legal in xml.

From http://www.w3.org/TR/2006/REC-xml-20060816/:

[2] Char ::= #x9 | #xA | #xD |...