PF usage is through the roof because Windows is starving.

You need to set the max memory of sql server low enough so that the OS will have 4-5 GB of...

How much ram available for the OS. PF is mostly used by the OS, not sql server.

Talking about a race, anybody got spare time for a "quick" fix?

http://www.sqlservercentral.com/Forums/Topic1198539-146-1.aspx

Apologies to bring this back on topic :hehe:!

I stopped reading 2-3 queries in. This is WAY too long to read and tune on a forum.

this is defenitely wrong =>

WHERE CONVERT(NVARCHAR(12),PE.PEDONE,110) = @StartDate AND SC.CATID =...

Certainly not the most obvious way to code this... but the fact is you still don't know.

Since 99.9999% of the systems need to work into multiple users mode, it's more...

Not disagreeing, just adding a 2nd point of view ;-).

Any reason against forced parameterisation?

Here's a quick overlook into your options => http://msdn.microsoft.com/en-us/library/ms191275.aspx

Jeff Moden (10/31/2011)

---

No we didn't. 🙂 And I rather enjoyed the display of prowess that...

Usman Butt (11/1/2011)

---

As far as blocking is concerned, it depends upon Auto Update Statistics option. If it is set to ON on the database, then we have further two options

-...

sqlzealot-81 (10/31/2011)

---

Updating stats should be done at less trafic time to avoid blocking. Instead of doing update stats i would recommande to find out the fragmentation level and do the...

tyson.price (11/1/2011)

---

I didn't see that being a requirement...where do you see that?

It wasn’t this:

“I need to pull data using multiple EXECs to get individual items. Example:”

Or this:

“Obviously, the output will...

sdownen05 (10/31/2011)

---

Not a problem, Jeff. Thanks for calling me on that.

I only want records that end in '_Syteline_HQ_App', so I just did this:

select left(JobName, patindex('%_[0-9]%', JobName) - 1)

from #JobName...

Evil Kraig F (10/31/2011)

---

Jack Corbett (10/31/2011)

---

Evil Kraig F (10/31/2011)

---

You guys are looking at a race,...

Elliott Whitlow (10/31/2011)

---

I have played (emphasize played) with this in the past but I seem to remember that I included some commands that were never executed in the code like...

How can you hide the code so that...