One of the most popular question I receive is usually about How to get column names from a specific table in SQL Server?
Question: How to get column names from a specific table in SQL Server?
Sometimes we need simple query which can do the task, then complicated solution. Here is a simple query which list size of the table in MB with Row Counts. I often run at my customer understand how many different tables they have and what is the row counts as well as the size of the each table.
Question: How to Find Row Count of Every Table in Database Efficiently?
Question: I just installed SQL Server 2016 developer version and new samples database WideWorldImports, upon expanding the tables, I noticed a special icon on the System-Versioned table which looks like a watch. What does this special icon which looks like a watch represents in SQL Server Management Studio 2016?