you have an awfull lot of plans in the cache for just one database.

are you using stored procs/parameterised queries? - have you tried turning on the setting for ad-hoc workloads?

looking...

i'm looking for something as simple as

DECLARE @c INT;

SELECT @c = DATEDIFF(d, '01/01/2019', GETDATE())*5/7;

DECLARE @h INT

select @h=COUNT(*) FROM holiday WHERE date_holiday BETWEEN '01/01/2019' AND GETDATE()

SET @c=@c-@h

SELECT @c

but maybe a little...

jeff - send me the info...

Many of us "like" a certain type of person. Not picking on you or implying you are this way, but often people that want to say everyone is...

this is one of those times where the query store can really help you (maybe)

if you can find that query in the query store (maybe as a regressed query) then...

100 % you can - all you have to do is make sure the unc path has the correct permissions for the account that is running the backup (normally the...

This really depends on your requirements (you haven't really given us enough to work on)

I would go for a single instance, especially if you are using linked servers in any...

I've had an argument with my ex partner in the past, she claimed that women were discriminated against in the software world.

the truth is that I don't care if you...

it looks like this could be a simple merge statement, maybe that's what they were looking for, but I agree with jeff..

last time I looked the GP data came embedded in the Clinical care group data (CCG) - but it's been 2 years since I touched that stuff - it was...

this might help

https://www.apexsql.com/sql-tools-plan.aspx

if you get Redgate sql prompt , there is an option to expand *

I believe if you look at apexsql website you might also find a free tool that also...

As far as I can see DBCC Dropcleanbuffers won't allow you to specify a database

but dbcc freeproccache can drop individual plans - if you can identify the plan handles by...

I'm sure someone will have a better solution, but I can only see this being done with a cursor and dynamic sql

you'll need a table mapping <fineamount> to whatever the...

• This reply was modified 6 years ago by MVDBA (Mike Vessey).
• This reply was modified 6 years ago by MVDBA (Mike Vessey).

post the command you are executing , we probably can't help you without the original syntax