It is very simple to find out the space used by any table in database.
USE AdventureWorks;
GO
EXEC sp_spaceused 'Sales.Customer';
GO
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Journey to SQL Authority with Pinal Dave
SQL, SQL Server, MySQL, Big Data and NoSQL
This is the best SQL Blog ever. TY.
Cool tip. I really enjoy your blog! I come here whenever I have a SQL problem. Thanks!
Hi Pinal,
Does it shows the excat data. Suppose there is bulk operation happed in that case it will show the excat data..?
Hi Pinal,
Is there any way to use replace function for ntext data type. If i want to change a particular text in all columns and all tables in a database. How can i resolved it ?
Please suggest. Thanks in advanced
I think you need to run DBCC UpdateUsage before you run sp_spaceused in order to get a correct result.
You will need to have sa role to find the space usage of all databases. Is there any work around for this?
Sir m storing image of visitorsand visitor data in a visitor table. The database has become to heavy i doubt its becuz of the size of image is there any way to know the size occupied by a specific column plz. let me know on my email id
Hi Sir,
Could you please tell me how to write query for “Find Space Used For All Tables in single database or instance level database ”
Rahulreddy
[email removed]