Hi,

also this query  had run few minutes in sql 2012 and now run hours in 2016.
Thanks,

Hadrian

thanks all Guys for helping me to understand some performance issues with this query.

MSSQL 2016SP1

Hi ,

I attaché execution plan for the view ,query returns more than 7 millions rows .

Thanks,

Hadrian

initial request was to replace views with indexes views with clustered index on it in order to improve performance. indeed I will check the index ...

sorry a derived table was in message error

not the for indexed view, but when I try to create an index on this view created with schemabinding) I cannot because it use a correlated subquery.

Thanks,

Gabriel

thanks for your support Our sysadmins wish to install a new cluster on NEW SAN .

KR,

Hadrian

thanks for your support Our sysadmins wish to install a new cluster on NEW SAN .

KR,

Hadrian

I come back with some details- we have two node cluster 2012 and we should move on new SQL cluster 2012 with disks on the new...

Thanks Perry,

I agree with OS ,I urged to upgrade OS ,too,but my decision is not taken by me.My question is in fact if there are changes in setup a new...

Thanks Perry,

Is just for test(managers asked to try this operation) .Please could you me an argument why?

first success to restore the database on the server B with a new certificate backup and new password taken from server A(as you said).

Now it remains to test what...

I try to understand how the TDE it's working,i begin to test restore on another server,I've just received this new situations ,TDE could not be turn off.

Thanks for you time,

Hadrian

This is working?

Install SQL Server Binaries on Server B (exact same build including all hotfix and patches as server A)

Move or copy the backup of the server certificate and the...