Hire someone who knows SQL Server, probably a contractor, and have them look at your database.

Something is causing the blocks. Till you know what, and solve it, nothing else...

I'd have to go with "it depends".

If you're doing the assigned duties of your job correctly and efficiently, but can't do anything beyond that, you're not failing your employer. ...

ZA_Crafty (9/22/2009)

---

my 2c on why this is happening...

It became simply too easy to ask something on a forum, or search it on google.

Welcome to the New Generation of IT.

If you...

Lynn Pettis (9/22/2009)

---

Jeff Moden (9/22/2009)

---

Lynn Pettis (9/22/2009)

---

First, leave it to you squeeze another 33% out of a routine, awesome. I'll have to incorporate that change into my code. ...

Jeff beat me to the punch on limiting the total number of rows processed as an added speed boost.

Lynn, try this with the function:

select *

from dbo.ufn_tally2(1,-1,1);

You can correct for that...

Jeff Moden (9/22/2009)

---

timothyawiseman (9/22/2009)

---

Great article Lynn. It seems that even if you aren't permitted to change the schema that if you are going to use it multiple times you...

Lynn Pettis (9/22/2009)

---

row_number() over (order by a1.N)

Something I have noticed when working with the windowing functions in queries using them, if the...

I'd also be more inclined to believe that it's either a parameter sniffing problem, or a case of where you really need two different execution plans.

Have you tried running it...

Is this part hard-coded:

(empcode between '99201' and '99205' or empcode between '99211' and '99215' or

empcode between '99241' and '99245' or empcode between '99354' and '99355' or

empcode between '99381'...

I must be doing something wrong. I've...

Lynn Pettis (9/17/2009)

---

Hey, one a different subject, how come I haven't seen any responses from the denizens of The Thread regarding the article I had republished here on ssc? ...

Simon-413722 (9/15/2009)

---

I've been using pretty much the same concept for data deletion since quite some time ago already. It does the same job as Lynn's code, except done a bit...

Ol'SureHand (9/15/2009)

---

Not so sure about it.

MSDN...

Can you post both execution...

It'll have to be a job that runs in those databases, since create/alter commands don't play well with three-part-names.

Create a job that queries the DDL log for new objects, parses...