You can easily find yourself in the need to know the tables with no existing rows from a database, especially in data warehousing scenarios.
Tag: sql
How To #1 – Create a linked server with a different name
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.
Learning Corner #3 – SQL Server 2016 – Temporal tables
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