I'm afraid I don't know, in particular, why Task Manager wants a shared shema lock on a temp table.

However, regarding your increase in pressure on the Logon Trigger, check for...

Not without backups, no. You restore to a point in time, but you can't reverse to it.

Though, that'd be a really cool feature.

James Stover (4/21/2011)

---

Sometimes in large organizations - particularly government - you will see jobs advertised with very specific skills and experience. I've never been able to prove this, but I...

Phil Parkin (4/22/2011)

---

Actually, I think there is quite a nice way for SSIS to handle this - using...

Scott Carter-357760 (4/22/2011)

---

Thanks Craig! That is what I was looking for.

The last end date was defaulting to getdate(), but I modified the second part of the isnull...

You really don't want to do this in SSIS. I hate saying that but you will not be well served by the number of multicasts and loops you'll be...

Steve Jones - SSC Editor (4/21/2011)

---

Oh. Em. Gee.

Are you guys having a deep technical discussion on some type of performance testing? Shouldn't that be a thread somewhere else besides The...

tjaybelt (4/21/2011)

---

i use this when i need a fast result.

SELECT

o.name AS [Name],

...

A little more description if you could between the without/with count differences? I'm trying to grok what the difference in the queries would be, count(*) shouldn't cause that much...

Hey Scott,

What you needed to do was island the groupings, then come back to them. I did this using some RowNumbering tricks. Take a look at the following,...

Not a cursor, but a while loop. Look at WAITFOR DELAY while testing for the applock's release.

I always recommend when doing an app wait delay that you build in...

EDIT: If Celko mentioned any of this, sorry, I pretty much simply skip his posts at this point.

What you'll want to do is JOIN on a subselect of SELECT Date,...

There are, but it requires a little extra coding on your part. For things like this, I like to use sp_getapplock. Use TRY/CATCH to make sure you release...

I assume because a lot of folks are like me and instead of researching, then answering, they...

Ninja's_RGR'us (4/21/2011)

---

tfifield (4/21/2011)

---

Great article Craig! I've been put off by job postings that have the SQL God requirement in the past. I'll never look at job postings in...