Good question, as it highlights the fact that the "GO" keyword is interpreted by the SSMS client, and is not part of T-SQL.

Hmm, that is very interesting that the trace showed the requested database as 'master' even though the login failed because of the default database. I have no idea how...

You are a member of Company\DBA which was added as a login, but do you also have a login created for Company\ME with a different default database specified? Are...

What about setting up an 'archive' disk array and partitioning the table(s) with the data to be archived on the 'archive' disk array?

Luis Cazares (9/12/2012)Width-sensitive will compare characters that are "the same" but will use one or two bytes depending on their definition.

It's not width sensitive of the strings but for the...

Thanks for the question... I never understand these collation quirks.

According to the documentation:

_CS_AS = Case-sensitive, accent-sensitive, kana-insensitive, width-insensitive

If it's case-sensitive but NOT width-sensitive, why is "peppers" at the end??

Great question Ravi, thanks!

Interesting note about traceflag 610 SQL Kiwi, I was not familiar with that traceflag.

Here is some more information on it:

http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

EDIT - fixed a typo

It may be minimal, but there's still an overhead, so I wouldn't run traces you don't absolutely need.

I generally only use them temporarily while tracking down an issue,...

Ugh, I've got to stop answering these questions first thing in the morning.

Great question though!

Nice question. I've only ever used it with a TVF... It is interesting to know it works with subqueries as well.

Very interesting, thanks for the question Waynes!

Excellent question. I remember this causing me a great deal of confusion when I first ran into it.

guerillaunit (8/31/2012)

---

It was a DB backup operation that took much longer than usual (1 hr vs. 5 + hrs.). I stopped the process and it has been in "Kill/Rollback"...

guerillaunit (8/31/2012)

---

Thanks Michael. I was hoping to avoid the restart, but it looks like there are no alternatives. I've never restarted a server before. Any things to...

guerillaunit (8/31/2012)

---

I have an uncommitted statement in perptual rollback mode in my database. When I try to kill the SPID associated with this statement, I get the "transaction rollback...