It is always fun to receive a follow up comments when I write a blog post. Yesterday I wrote about SQL SERVER – Simple Query to List Size of the Table with Row Counts and here is the follow up question which I received about adding a NULL column.
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?
After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
Question: How to Find Running SQL Trace? Once we know the trace exists, how to stop and delete them?