That's a horrendous complicated query! Personally I think it needs a complete rewrite.

But if you don't have time and want to improve the performance the first thing to check is...

27 seconds is quite a long time to delete from a table if the system is live. You could come across errors where inserts and updates are failing as the...

You could write a stored procedure to return the results, with a parameter of jobname. then just grant them permissions to execute the stored procedure.

What does it say in the history of the scheduled task?

Have you got the correct folder in the Start In option under Actions?

Thought it might be worth adding some bulk test data:

-- You'll need Jeff Moden's Tally table for this http://www.sqlservercentral.com/articles/T-SQL/62867/

TRUNCATE TABLE [dbo].[OfficeCounty]

DELETE [dbo].[County]

DELETE [dbo].[Office]

-- Generate 26*26*10 counties (10 counties in each...

Lynn Pettis (6/4/2015)

---

Jonathan AC Roberts (6/4/2015)

---

The reason a semicolon is required before the WITH in a CTE as that WITH has two uses, it can be used for hints e.g....

The reason a semicolon is required before the WITH in a CTE as that WITH has two uses, it can be used for hints e.g.

SELECT * FROM MyTable WITH...

asushil (5/15/2015)

---

Interesting Solution way back i was looking such solution for printing bar Code Labels for given no of item for given number of times.

some expert gentlemen on MSDN...

But it doesn't do the same thing. The function I wrote displays the value of an int in...

To do what?

Mark D Powell (4/28/2015)

---

Unless I typed over the comment by accident there is an error in the comments since BitsIn returns 4 for an input of 15 while the comment...

Well it probably is bit of an obscure/esoteric thing to do but one of the most efficient ways of storing items that are switched is in a bit string within...

Michael Meierruth (4/28/2015)

---

Jonathan AC Roberts (4/28/2015)

---

~ is the T-SQL's bitwise NOT operator. It inverts all the bits in an integer.

It's used so the right-most bit, which is set to...

~ is the T-SQL's bitwise NOT operator. It inverts all the bits in an integer.

It's used so the right-most bit, which is set to 1 two's compliment signed integer...

There might be the odd special situation where this is a good idea and will work but from what I can see you need to rely on there being a...