This is the problem line (or at least the main problem)

If that select returns more than one row (which will happen if...

The exam wasn't that bad. Much easier than I was expecting. Easier than 441 or 442.

It's pretty much the same format as the other ITP exams. No major surprises. It...

*sigh* I keep getting posts in the wrong threads when I'm replying to 2 or more at a time. Isn't consistent and...

One piece of advice I will offer you, based on some recent experience conducting interviews.

Leave the arrogance at home. It's the fastest way to end an interview. Be confident, yes,...

I've found table variables fine for <10 rows of data. Past that the lack of statistics and resulting poor cardinality estimate tends to stuff up the optimiser ten ways from...

If you look at the execution plan for that query, do you see an index scan or an index seek for the table INFO_LOG?

Edit: Looked a little closer

That's a rather...

Fortunately for my server (I found that in production), the data was such that the resulting string always was >7600 characters by that point.

Char/varchar aside, what's wrong with the SPACE...

Because it's not necessary. If you're filtering with an equality on the...

So what's view based on? Another table? Several tables?

Replied via PM. I don't want to hog this thread any more than I...

Grant, that's seriously impressive. How anyone can debug that for more than 2 min, I don't know.

Seeing Grant's reminded me of this little time bomb I found a couple years...

Please don't cross post. It fragments answers and wastes people's time. If you posted in the wrong forum, you should be able to delete the thread.

Continue here

Jeff, may I send that to my boss?

I've got a meeting with my boss on Monday. Will see what comes out of it. If it's OK, I'll drop you a...

The two are equivalent, but you should convert to the inner join format. The old style joins are deprecated in SQL 2005 and will not work in future editions.

Regarding the...

It doesn't usually matter which one was the victim when it comes to resolving deadlocks.

To stop them happening, you'll likely have to look at the code that the...