Hugo Kornelis (11/2/2011)

---

My guess would be that your server has a default collation...

SQL Kiwi (11/1/2011)

---

Hah! Well I came across this collation behaviour with SQL_VARIANT when I was thinking one day about how EAV systems would work when confronted with string data...

Thanks for the question.

However, I'm curious about the discussion to follow, as I personally find the wording ambiguous 😉

In order to be able to carry out a (plain English) full...

Hardik Turakhia (10/28/2011)

---

http://msdn.microsoft.com/en-us/library/bb964711%28v=SQL.100%29.aspx

This link states that LineString and Polygon are geometry data types.

Then in answer...

Koen Verbeeck (10/27/2011)

---

Nice question, but answer number 4 was also incorrect, as both are of the geometry datatype.

A polygon can also be a geography datatype, but according to MSDN, Linestring...

Greg - KPS, LLC (10/18/2011)

---

Where is the minimum of 6 specified? Was I sleeping? I was thinking the same as the previous post but didn't understand where 6...

I'd guess Microsoft increased this number with the introduction of filtered indexes...

Got it right--for SQL Server 2005 😉

Thanks for a straightforward question.

And you might find this link helpful as well.

Regards,

Michael

L' Eomot Inversé (9/22/2011)Are you sure that you were running mirroring in High-safety mode with automatic failover?

According to the BoL page on Replication and Database Mirroring (and corresponding...

chris.mcgowan (9/22/2011)

---

... As this caused us quite a few issues as we have external facing customer websites accessing the subscriber databases a decision was made to enable trace flag...

chris.mcgowan (9/21/2011)

---

What I mean by pausing is if you run the below on against a mirrored database.

ALTER DATABASE DatabaseName SET PARTNER SUSPEND;

Granted I should have used the word suspend instead...

archie flockhart (9/6/2011)

---

#3 got me; didn't know that it would identify the correct column automatically in the order by clause. I would always specify the table in these circumstances,...

I may be wrong, but as far as I know, you cannot create...

Thanks for the question.

However, I do not quite agree with your answer that the query you provided is 'a bit of a trick question'; I'd rather consider it testing the...

Dhruvesh Shah (8/2/2011)

---

bitbucket-25253 (8/1/2011)

---

Dhruvesh Shah (8/1/2011)

---

My server got hang. but from memory i have setup my instance as US. Can some one pls advise how can i find out what's...