Roy Ernest (10/12/2011)

---

Just sorted out the issue. It was doing parralelism. i asked them to rewrite the query. I have no intention of dropping the CL Index on that monster...

SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))

check out the switch statement

jared-709193 (10/12/2011)

---

MysteryJimbo (10/12/2011)

---

Ninja's_RGR'us (10/12/2011)

---

I've yet to see a single client trade data quality for a little extra performance (never had a lot with correct tuning on the system).

Once you tell...

Run the report from VS (should be easier to spot in the trace, but either will do).

You point the trace to whatever sql server the report gets the data from.

Just a PS. Doesn't work on 2K5 :angry:

You should sign up for his newsletter... great stuff every week.

http://www.sqlskills.com/JoinCommunity.asp

I've yet to see a single client trade data quality for a little extra performance (never had a lot with correct tuning on the system).

Once you tell them it's certain...

http://www.sqlskills.com/InsiderContent/201108/August2011InsiderTip2.wmv

http://msdn.microsoft.com/en-us/library/ms174997.aspx

But if you don't see anything in the GUI I really don't expect you to see anything in there.

Well in this case without backup you can't do anything unless maybe you have verbose logging on the agent.

You could see something similar to this :

Date10/12/2011 10:30:00 AM

JournalSQL Agent...

If you have msdb in full recovery and a full backup prior to the delete then you can take a log backup and restore msdb to a new name before...

Just a PS, that's why Paul Randal's always does a job to cycle the error logs daily and then keep 99 days.

You can more easily spot what and when something...

CoolCodeShare (10/12/2011)

---

Hi,

I believe that your backup file is corrupted one. Please take back up again.

Please use RESTORE VERIFYONLY option to make sure if the back up is not corrupted.

You...

And I've seen a virus with this exact behavior (was 60 secs but still).

I've also seen a screensaver peg the cpus at 100%.

Both of which could only be seen while...