salesprod
asked on
calculating space
I have an Orders table with initially 5,000 rows and it is estimated that it will have in average 30 orders daily. The orders need to be kept for 6 months, before it is archived and deleted from the database. How do you Calculate the amount of space that needs to be reserved for the Orders table. are there any assumptions when calculating the
table size.
table size.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
not sure if this is the method in working out the problem.
please advise. thks
EXEC sp_spaceused 'orders'
SELECT COUNT(*)
FROM orders
please advise. thks
EXEC sp_spaceused 'orders'
SELECT COUNT(*)
FROM orders
ASKER
https://filedb.experts-exchange.com/incoming/ee-stuff/5633-New-Folder.zip