just make sure no-one tries to put a stored proc call inside the trigger making an assumption that it is single row only.

I've inherited triggers where they have put checks...

is the locking at the sql level (ie in sql monitor or sp_who2 you can see a blocked process)???

I know with 1000 reports it's not feasible to go through all...

Wow,

I just came off the back of speaking at data relay in Nottingham on this topic

we've been in business since 1851 (ok it was a bookshop back then) and most...

I can see you are using a string split function - the longer the string, the worse that function will perform.

although the number of UNION ALL statements in there will...

I did post a reply, but it didn't save it

i'm guessing that you want something like this

SELECT *,ROW_NUMBER() OVER(PARTITION BY customerid ORDER BY stage) AS rnk FROM #t

but you have...

you are going to have to roll out your own log shipping system

it's not that difficult - but i'm guessing many other people will have better solutions

create a table on...

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