You can read about this behavior in the book

"Pro SQL Server Internals" by Dmitri Korotkevitch, Chapter 1

Furthermore if the majority of the rows will contain NULL values, the sparse column...

If one considers the requirement to understand and practice the relational data model of a SQL database as a drawback, then NoSQL is in favor. Otherwise, I am still waiting...

Thanks for you help.

The hotfix is described as available for: 6.2.920 0.20 xxx Windows 8 and Windows Server 2012

If we get the issue on a test server I will give...

https://docs.dbatools.io/#New-DbaClientAlias

Maybe clumsy, but works.

(But of course there is always potential for optimisation.)

"How to handle the server name change ? App config files will have source name in the files. If I shut down the source, rename the destination and source ,...

Thanks your response.

Yeah, I think the most important question is if this is really my passion. My hope is to build up additional expertise beside my humble SQL Server knowledge.

I´m...

"if it's 1000 servers" -> No, it's only round about 300 servers.

"so script up a job and deploy it everywhere that sends you all the info you need (backups worked?...

Thanks, that's indeed very helpful.

Let me add some remarks:

1. Yes, I fully agree. Actually one reason for hiring me was to get rid off all the < 2016 instances, an...