when you script it (as jeff correctly suggested), run activity monitor or sp_who2 and see if the process is being blocked

not wanting to teach anyone to suck eggs, but your...

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

Personally i'm still a little old school and I like to go and see all the blinky lights on a server.

But I have found that choosing an azure or AWS...

I've always found with migrating CLR assemblies that you are better off scripting it from your old server

it will generate a CREATE assembly script that includes a big old binary...

sounds like you need to use sp_attach_single_file_db

https://www.bing.com/search?q=sp_attach_single_file_db&form=EDNTHT&mkt=en-gb&httpsmsn=1&plvar=0&refig=57541506b54e4ec09e00e6b589d1352b&sp=3&pq=sp_att&sc=6-6&qs=AS&sk=PRES1AS2&cvid=57541506b54e4ec09e00e6b589d1352b&cc=GB&setlang=en-GB

so - hold on - are you guys saying that I should put every Saturday and sunday into my holidays table?  that kinda makes sense.....

all I have to do is...

so if it's a call logging system.... you probably read more than you write... can you go through the code and find "appropriate" places to use NOLOCK

NOLOCK is not a...

can you give us an idea of what the application does - it might help give us some context on what areas to look at

I did notice that you don't...

The AG shouldn't matter (assuming you are talking about availability groups)

optimise for ad hoc workloads is a setting for the server (right click on the server in management studio and...

Without wanting to give away the answer, the script creates an empty table variable that it populates to generate a select.  So I would look at rewriting the entire...

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...