Recommendations: keep it within the applications specs.

Downside of having nvarchar too big:

More memory reserved in applications / sql server for retrieval of data as each field can hold more data.

No...

Thanks for mentioning sys.dm_db_persisted_sku_features, didn't know it existed

I personally dislike single letter aliases, usually too short to have a representative meaning. With a as (), b as (), c as (), d as ()  . Select ......

SELECT REPLACE('ABC*1234','*','00000') newvalue

Probably there is a filter active on tablix, dataset, ... Do you have the same problem in a blank report with just the sp?

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 6 years, 4 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...