MB-400824 (1/25/2011)

---

Craig,

sp_calculations does not make any subcalls. The way I have the proc is that I create the T-SQL on the fly. I try to minimized code maintanence, so, I...

Do you actually get...

Having the table definitions would help, but some of your logic seems a bit odd.

Based on the way your query is set up, this WHERE Clause is always true: ((@RTSelection...

By the way this is an issue on SQL 2005. If you detach a file and copy/move it to a new location you lose permission on the file. For this...

ramadesai108 (1/13/2011)

---

Thanks for the articles. So there is no way of knowing whether the object is cached or not. But what I can look for is consistency whether the same...

Here are two articles, unfortunately both a bit old that expand on this....

I know, and so is trying to work out what exactly Profiler is...

We are busy testing it or our clients. I'll let you know when we give it a thumbs up if you want.

Leo

Reducing READS tends to be...

You may also want to run this: select * from sysjobhistory

Leo

Have you run: SELECT name, job_id from msdb.dbo.sysjobs where name = 'Backup_WebReq_Log' ?

Possibly check all your SQL Servers

Leo

Do you possibly have another server that is running the job?

Leo

What I...

Craig Farrell (12/30/2010)

---

This is nothing new. IT is a cost. Yes, we're a cost. The business makes money, we support the business, we're a cost of doing...

I can't see much besides the insert into...