Use synonyms, views on srv 2 ? Srv3 queries srv2 (which queries srv1)

Music is certainly a help to cope with the isolation. Rediscovering my cd-collection and noting down some of the better songs

An exclusive lock on a table is quite drastic. Which isolationslevels are in play? http://thesqlgirl.com/2016/11/01/sql-transaction-isolation-levels/

We are also using Veeam to do our SQL backups.

1. It is possible to restore to point in time. Test it. We originally had some problems with timeouts on restoring...

You got me. Nice one

Is SQL browser running?

I don't think you can limit it to a particular database. Security is handled with linked server login mapping and the destination can also block certain logins

https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-ver15

• This reply was modified 5 years, 9 months ago by Jo Pattyn.

Glad you found your solution. Thanks for posting it

With a rectangle ? Show on page 8, add a page break

Have a look at the (actual) query plan after the execution of the stored procedure to show what SQL is executed.

Brent Ozar is currently presenting a tuning week online (til...

Where did you find the variable declaration stuff?

If you have a baseline of workload before, you could compare it to baseline after.

Otherwise: user response?

Holy smoke.

I don't know for our company. We've got internal generators to make sure labtests are completed. Internet dependency has increased lately

Thanks for your solution

Working from home is plenty distracting. Beautiful weather, beer in the fridge, free choice of radio