.... non answer.

What application is causing this (I have something similar)?

I've had hints to solve this but I never did. Maybe we can have a whack at it together...

During dev, I use query (allows to use wizards and for fast edits of adding / removing stuff). However this might not be so true if you have templates...

Can you post the table DDL and the row in question along with the exact update statement? We can't really try to help without seeing exactly what you see...

GilaMonster (7/11/2011)

---

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

---

I had forgotten about that one. Most of my reports have to use the WITH RECOMPILE because the date ranges vary too much.

Because of that...

GilaMonster (7/11/2011)

---

The plan compiled for that will have to have a check the second condition. That's because the plan has to be safe for reuse and if the plan had...

USE [master]

GO

EXEC master.dbo.sp_serveroption @server=N'LOCALSERVER', @optname=N'rpc', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'LOCALSERVER', @optname=N'rpc out', @optvalue=N'true'

GO

That's the only alternative I could get to work..

EXEC [linked Servername].msdb.dbo.sp_start_job N'JobName'

What is the frequency of index defrag and stats updates?

What are the column's datatype in the wehere clause?

Are you waiting on something to send us the actual execution plan?

No I was simply joking.

Short of adding ressources, limiting ressources usage is the only other option here.

GilaMonster (7/11/2011)

---

Can be. Not as simple as that, but it's about giving the optimiser the option and seeing what it thinks.

Back to the original question though, short of better hardware...

That works great, but only since last server restart.

http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx

Please post the actual execution plan. Table DDL, including keys and indexes.

IIRC that book first came out on amazon. Then it was brought...

Close enough! :w00t:

I'm 10 minutes away from the airport in case of emergency!

calvo (7/11/2011)

---

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

---

calvo (7/11/2011)

---

Ninja's_RGR'us (5/3/2011)

---

Thanks for the not posting... allowed me to steal the #5 spot in the last 30 days :-D.

Now I know this is going to cost me......