The External Activator is announced and discussed here[/url].

Heh, glad we could help. 🙂

Paul White (4/21/2009)

---

Phil Factor (4/21/2009)

---

...the difference in the results that we are getting is due to the way different servers behave with different resources and configurations. I do my testing...

I agree with Gail. Threading from CLR is definitely on the list of "Things most likely to crash SQL Server". You really ought to take a different approach....

Thanks, David.

You'll have to give us more information than that. What would help us are table definitions (as CREATEs), sample data (as...

Great article, Alex! lots of useful tips and information, thanks. 🙂

Well, I am a little confused. Why isn't CheckInID sufficient as a primary key & ordering principle?

I believe that this will do the job:

SELECT Distinct UserID

From (

SELECT *

, ROW_NUMBER() Over(partition by UserId, Comment, CmtTypeGrp order by CheckInID) as GrpCnt

From (

SELECT CheckInID

, UserID

, comment

, ROW_NUMBER()...

Be sure to read the discussions attached to the Questions though. A lot of the questions are somewhat ambiguous and may need clarification to be fair in an interview.

Wesley Norton (4/20/2009)

---

90%?!?

I'm not disagreeing with you, as I see similar situations in other walks of life, but sheesh, doesn't that just blow your mind? Maybe I have been thinking...

Jack Corbett (4/20/2009)

---

Another note for the non-Twitterer's is that there have been 358 sessions submitted to PASS so far, deadline is Friday at Midnight, for about 80-90 slots available. ...

Wesley Norton (4/20/2009)

---

Maybe it's because I'm fairly new at this, or maybe it's the way I think. But I have to hope that my response would be something close to:...

No way.

Paul White (4/19/2009)

---

It's just occurred to me that there was a great opportunity back there for you to use a line like:

"I find your lack of faith (in...