sknox (8/25/2016)

---

The correct answer is "it depends."

MOST of the time you'll get two rows as explained in the answer.

HOWEVER, each GETDATE() within each SELECT is evaluated separately. When the separate...

Richard Hendrick (5/12/2016)

---

Indeed. The "limit" in this question is ambiguous. I would assume the limit on CPU using resource govenor would be the hard cap limit, not the maximum...

As I understand it, the transaction log backup at 8pm will contain transaction log records from when the previous transaction log backup was taken (7:45pm) until 8pm. So if you...

I like the ones where you have to try and figure out what's wrong with the question, then go for the option you think the questioner intended - thanks Steve!...

That must have been amazing to see, one of those things where you have to actually be there to appreciate it, like an eclipse or the Grand Canyon - pictures...

Thanks very much for these examples Hugo, very useful,...

arnierowland (12/25/2015)

---

Try this one:

SELECT geometry::Parse('POLYGON((

4 0, 0 0, 3 2, 1 2, 3 4, 1 4, 3 6, 2 6,

4 8, 6 6, 5 6, 7 4, 5 4, 7...

Carlo Romagnano (12/28/2015)

---

The "order by" clause misses!

Try this:

declare @image as table (

row_id tinyint

primary key clustered (row_id desc)

);

insert into @image(row_id)

values(1),(2),(3),(4),(5),(6),(7),(8),(9)

select

case

...

What about Son¥?

PHYData DBA (12/2/2015)

---

Stewart "Arturius" Campbell (12/2/2015)

---

tom.w.brannon (12/2/2015)

---

I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These...

Stewart "Arturius" Campbell (12/2/2015)

---

tom.w.brannon (12/2/2015)

---

I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are...

Nice question, not because it's really necessary to know the names, but for the explanation of where the names come from.

happygeek (11/4/2015)

---

Sean Lange (11/4/2015)

---

sipas (11/4/2015)

---

And this question comes from someone with an apostrophe in their name - surely a shameful practice that needs to be eradicated in the interest of...

It's...

Ooooh, the sneakiest question in a long while - should/cannot - definitely open to interpretation. Like all dodgy questions, people may still learn from it, but I think it's better...