Mostly here. But sometimes I go over to the MSDN forums because they get some questions over there that I do not see much here (like Service Broker). ...

That's why I always spell it out the first time that I am responding to someone I haven't seen before, like "...BOL(Books Online)...", though now I am thinking that that...

rsaylors (6/5/2009)

---

Gail's article was a huge help in understanding how T-Logs work, and the various recovery models, I would like to be able to automate the backup of the T-Log...

Try it like this:

WITH ctePX as (

Select CaseID, ListOrder, MAX(Code)

From CasePXCodes

Where ListOrder Between 1 And 10

Group By CaseID, ListOrder

)

, ctePXList as (

Select CaseID,

Case When ListOrder = 1 Then Code Else...

Steve Slaughter (6/5/2009)

---

Thanks Grant for your observations. That is what I am working on, getting control of the indexes. The tuning adviser recommended the covering index which sped up the...

Ooh, good point, Marcus.

Sorry, it works fine for me?

Can't remember if this works in SQL 2000 or not:

SELECT

StudentID,

SubjectID,

(Select SUM(subjectMark)

FROM

(

Select TOP 4

StudentID, SubjectID, subjectMark

From YourTable as t

Where t.studentID = g.studentID

And t.subjectid = g.subjectid

ORDER BY subjectMark

)...

No, I was just referring to the fact that there has to be cross-CPU synchronization of some kind in order to correctly implement a sequential counter, whether it's mutexes, semaphores,...

The price or serialization in a multi-processing environment. Unless...

I'm not sure why wouldn't be able to unit test anything. Do you have some kind of specifc requirements for unit testing that a CLR UDT might not fit?

Hey, Jeff is back! 😀 Great stuff Jeff.

Glad I could help.

SQL_Quest (6/3/2009)

---

Hi,

The package runs OK in BIDS. It does not give me any errors, but I am...

This...