You can easily find yourself in the need to know the tables with no existing rows from a database, especially in data warehousing scenarios.
In some situations when you are creating a linked server you will want a name for the object that is different from the machine name.
SQL Server 2016 introduces support for an interesting new feature, called Temporal Tables. As you may see on other sites as well, this comes with the following warning: Don’t confuse them with Temporary Tables! I will try to explain in this post (and maybe in some others, following this one) the main functionality of the Read More