GilaMonster (7/4/2011)

---

But there are so few...

GilaMonster (7/4/2011)

---

I've reported it (long time ago), not least due to the insults he was tossing at me earlier on

certs don't mean squat unless you have...

nathanr 81822 (7/4/2011)

---

I have used all my grace trials... and it is on a production server.

I dont really want to install anymore 3rd party apps on it that will...

From our beloved http://www.sqlservercentral.com/Forums/Topic1134935-146-1.aspx

Perry Whittle (7/4/2011)

---

The same thought...

Red-Gate has a trial for sql compare and sql data compare.

I have some script but they are to rudimentary to share.

Run this query and post the results here.

http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

Perry Whittle (7/4/2011)

---

Hmm, Hours or Minutes are the only frequency options for a job schedule!!!

can you post details of the backup, copy...

quan23 (7/4/2011)

---

Aha, I was thinking that local #tmp tables don't have statistics generated for them, but I was getting confused with table variables

That solves the potential issue with concurrent users...

pwalter83 (7/4/2011)

---

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

---

quan23 (7/4/2011)

---

Would you make the creation of the temp table conditional so you only create it if the passed in parameter contains a ',' character?

(I am assuming...

You can do select into #tmp. Which is a local temp table.

I personally choose to explicitly drop them for code clarity. But it's not necessary.

This is a nice...

Make sure to take a snapshot of the waits before changing the setting.

And clear the wait stats cache so you get a fresh report in the coming hours / days.

quan23 (7/4/2011)

---

Would you make the creation of the temp table conditional so you only create it if the passed in parameter contains a ',' character?

(I am assuming here that...

as2higpark (7/4/2011)

---

Awesome, thanks guys.

I am going to set to MAX of 0 and Cost Threshold of 18, the query to see the plan caches actually showed a TON of them...

Create a setting table.

update set field = 1 at the top of the query.

Then 0 at the end.

Schedule to run the proc every 15 minutes. 1st statement is to...

as2higpark (7/4/2011)

---

...forgive the dumb newbie...I was confusing the 2 settings.

Sorry, I have not touched the Cost threshold setting yet, only the max setting. The cost is at 5 and the...