MS SQL Server - TABLE SPACE

Author

TABLE SPACE

Kalyan

2005-03-31, 8:01 pm

HI

I have tables with 4 years data with NO DATA COLUMN . Is there any way to
find out, what is space used by table for given year (say 2003) or is there
any way to find number rows inserted/update for given year (say 2003)

thanks
Kalyan

Tibor Karaszi

2005-03-31, 8:01 pm

SQL Server doesn't track date/time for insert or updates, it would be a huge overhead for those who
do not need that. If you don't have a column that track the information, then the information is not
there.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
http://www.sqlug.se/

"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news:1A0B2838-907A-4171-9945- D5DBB16D770B@microso
ft.com...
> HI
>
> I have tables with 4 years data with NO DATA COLUMN . Is there any way to
> find out, what is space used by table for given year (say 2003) or is there
> any way to find number rows inserted/update for given year (say 2003)
>
>
> thanks
> Kalyan

Sponsored Links