Great question. Had to reread to catch the problem because I knew that nobody would intentionally create user objects in tempdb.

Hugo brings up a good point as well about...

Good question today. Learned something which makes it worthwhile

Thanks Jessica, very good article.

I remember that when I was interviewed for a position at a very large company, the one question that stands out in my mind was "Do...

Hugo

Mostly queries that report aggregated data for an audience that doesn't care about the exact number, but only wants an indication. If the numbers my query produces will be rounded...

First - this was a very good question. Learned something today which is great.

Hugo

Shame about the (nolock) hints, though. They serve no purpose, and they might lead people to believe...

Can't wait for this one. Hope that it is as informative as this thread has been.

ROFLMA

That's how I do it, one a day like a vitamin.

Really, why do you want to delete a production database? Especially when you don't know...

Very good question - actually gets the blood flowing.

Sorry, in this case, I don't feel that the responsibility falls upon you to do the research for the correct answer. The answer provided sounded viable,...

Nakul Vachhrajani, very good question.

Unfortunately

Nakul Vachhrajani

That's why said "the test above shows that..." - I didn't have the time to do the detailed reasoning when I encountered this issue...

Manie:

Your answers are wrong. You state that you can pull data from multiple rows, yet BOL which you state as your reference says

No column reference pulls data from...

Good question - after the fun with transactions, nobody should have gotten this one wrong:-P

I did it the lazy way, used the GUI

I wouldn't "lose" the schema binding if I...

I recieved the following error when attempting to alter a table with a view which was created with schemabinding:

Warning: The following schema-bound objects will be modified:

- View 'dbo.test_vw':...

Good question - good chance to review