'Calculating data used based on SELECT statement in SQL
I have a DB that has two large tables that store some data with a DATETIME column. I found some queries that can display the total memory that the table takes but I wanted to take it one step further. I want to see how much data is stored in the table in one day. For example, we have table T1 with columns TimeStamp, var1, var2, var3, ......etc. I want to select the data for a specific date range and calculate the amount of data storage based on the data selected. Is this even possible? I can't find anything on it.
Select * from T1 where TimeStamp > date1 and TimeStamp < date2
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|