Even though I'm from the U.S., I do enjoy the British comedies that are shown on our public broadcasting system. It is unfortunate that most of them seem to be...

Using DATEPART you can get the quarter or week. However, since DATEPART works with the calendar year, if the financial year is not the calendar year, you would have to...

ctics112 (7/21/2008)

---

IF EXISTS (SELECT State FROM #temp_Agents WHERE State...

Lighten up people. Being so stressed out will take years off your life. There's enought stress in our work lives. Is the answer to a QotD worth losing out on...

Try the code here

http://www.eggheadcafe.com/articles/20030626.asp

When BOL discusses row size, it refers to in-row data, not the length of all the data in a record. So LOB storage is not included.

Then why does Google come up with 1,380,000 results for Oracle...

To me it sounds like SNAPSHOT transactions issue a shared lock request so that it will wait until the rolled back transaction or database recovery has been completed. Once that...

Getting the red error message is easy. Just type SELECT and execute. A red error message will appear which can then be changed to whatever you want and it will...

I don't know much about MBA's. But, Guy Kawasaki of Garage Technology Ventures, a venture capital company, increases his estimate of a company's value for every engineer it employs and...

The question didn't ask where does the Resource Governor get its information in order to work. It asked at what level does it work. It may get information from the...

Was it a clue that there were three answers since the question was worth three points?

Technically, you can't move a database with sp_attachdb and sp_detachdb since they don't exist.

I use to worry about the points, but life is too short to worry about such unimportant things like that.

I think the point of the question is that unless you know how windowed aggregation works, it is a gotcha.