You're probably going to need to use the collation hint on the joins if you use that function.

I don't use a function for string parsing, I use an inline query...

If you use a CTE and the Row_Number function, ordered by the datetime of the data, it's pretty easy to join a row in a table to the row before...

I recently had a problem because of a virtual server. The server was running really, really slowly, and nothing seemed to be causing it, so far as I could...

Lowell (7/28/2009)

---

OK I've got ~140 or so points accrued from the QOD section, that are not applied yet to the points viewed in the forums; right now my rank is...

Mad Hacker (7/28/2009)

---

While I feel that we should always strive to get it right the first time, the requirements (user demands) tend to be dynamic by nature, which means that...

Well done!

SQL Standard is server software. It's not meant to be installed on XP, it's meant to be installed on Windows Server. There have been problems with installing it...

Those will work, but if you implement code like that, it's much harder to document, because it doesn't have as natural a logic-flow. Make sure you include a full...

Personally, I think the observations in the article and in many of the responses come under the "primitive astrology" heading.

Many years ago, I saw a comic in a newspaper, which...

She Through Whom All Data Flows (7/27/2009)

---

Thanks! That's what I was missing. Although I can't right now think of an example where I'd want Xact_abort set to OFF.

I am...

Deadlocks are caused by unresolvable resource conflicts. Two jobs inserting into the same table usually won't cause one. SQL Server can usually handle it with locks.

I have plates with "GSQRD" on them. Nobody here will ever figure that one out! :hehe:

You need to have Xact_Abort set to "on" for it to work the way you expect. Check out "set Xact_Abort" in Books Online for the details.

I recently read an interesting argument in favor of publishing all SSNs publicly, and removing them from all security systems. Not sure I agree, but it should be considered.

Think it's interesting now? The current national health care bill in the US House includes a mandatory National Health ID, and the federal government is supposed to have real-time...