GSquared (7/27/2012)

---

Brandie Tarvin (7/27/2012)

---

Back to the semi-technical discussion...

If joining a VARCHAR(8000) to a VARCHAR(MAX) value degrades performance, how does one get around this?

I'm not speaking in the context of the...

Rob Schripsema (7/26/2012)

---

L' Eomot Inversé (7/25/2012)

---

I could remember 3 of the four answers, but on the mirroring one I was racking my brains to no avail, and finally gave up...

No, I think my DBCC CHECKDB question was actually worse. And I can rememeber being absolutely horrified by one or two that must have been even...

I dunno, these modern...

Stefan Krzywicki (7/26/2012)

---

Just make the last name "You know, that guy"

It is amazing to me not only how poorly thought out much security is, but that even giant companies like...

Sean Lange (7/26/2012)

---

How many people don't share a last name with their PATERNAL grandfather? Only unmarried women, or those that chose not to take their husband's last name. And people...

Nobody offered me 45 minutes :blink:. Senior technical people at ICL...

Dan Graveen (7/26/2012)

---

I was also stumped on the mirroring option. Did a quick lookup on msdn and found the alter database mirroring options are not available for contained databases. I...

ChrisM@Work (7/26/2012)

---

Tom, carbohydrate chemistry is a massive and important field of study which we barely touched on when I did my bichemistry degree in Aberdeen in the 70's, nevertheless I'm...

Came across something different the other day: Crabbies spiced orange alcoholic ginger beer. I think I prefer it to their ordinary alcoholic ginger beer, at least when the weather...

Nice straightforward question, thanks.

I could remember 3 of the four answers, but on the mirroring one I was racking my brains to no avail, and finally gave up...

sknox (7/18/2012)

---

Can anyone come up with a plausible scenario where it would make sense to create a clustered index with, say, 10 or more columns?

No fair coming up with a...

Nice straightforward question.

Maybe http://msdn.microsoft.com/en-us/library/bb934097.aspx is a better reference for this than the one given. The information there is much closer to the top of the page there.

Yes, it's very like a recent one.

Judging by the numbers getting it wrong it still needs airing. So a good question.

vk-kirov (7/19/2012)

---

Weird logic. I don't understand how the answer could be "No", while in fact the database can be restored from any of the snapshots (although not with a single...