Man Made Code
Statistics
Total Posts: 34
This Year: 0
This Month: 0
This Week: 0
Comments: 174
Admin
Sign In
Navigation
Home
imorfus (Complete Intranet Solution)
The Alchemist - India
Mix Match Parade
Developers Logic
Speaking Dodo
Programmer's Logic
i-Vista Digital Solutions Pvt Ltd
Recent Posts
How to limit the data returned by each columns in a SELECT statement?
How to swap data between two columns of a table in SQL Server?
Favicon – The little icon on the address bar
Smarter the better – SQL Server tips – part 03
Smarter the Better – SQL Server Tips – Part 02
How do I read excel file data columns as TEXT always?
Applying Windows Integrated Authentication in IIS 6 gives error HTTP 401.1 – Unauthorized: Logon Failed
Smarter the Better – SQL Server Tips – Part 01
Finding Stored Procedure Create and Modified Date in SQL Server
What is the max length of a file name or folder name in Windows OS?
On this page....
How to determine the size of a table in SQL Server database?
Archives
Full Archives By Category
2007 Calendar View
November, 2009 (1)
August, 2009 (1)
July, 2009 (1)
June, 2009 (1)
May, 2009 (2)
April, 2009 (1)
March, 2009 (2)
February, 2009 (5)
January, 2009 (6)
December, 2008 (12)
November, 2008 (2)
<
February 2009
>
Sun
Mon
Tue
Wed
Thu
Fri
Sat
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
1
2
3
4
5
6
7
Categories
CDOSYS (1)
Classic ASP (10)
Command Line (2)
Databases (16)
Excel (1)
HTML (1)
IIS (10)
Indexing Service (1)
Internet Explorer (7)
Media Streaming (1)
MS.Net (2)
SQA (7)
SQL Server (16)
Windows OS (2)
CDOSYS
Classic ASP
Command Line
Databases
Excel
HTML
IIS
Indexing Service
Internet Explorer
Media Streaming
MS.Net
SQA
SQL Server
Windows OS
Blogroll - Fav Blogs
Geek Speak
Gyan Guru
Acknowledgments
DasBlog Theme Design by:
Tom Watts
E-mail:
Theme Image by:
dreamLogic
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
Technology Blog
« Understanding and Using PIVOT clause in ...
|
Main
|
Converting a comma separated string havi... »
Thursday, February 12, 2009
How to determine the size of a table in SQL Server database?
You know how many fields are there in the table. You know the size of each field in the table. You know how many records are there in a table. But do you really know the size of a table? How much space is that table really taking?
SQL Server provides a built in stored procedure that shows the size of a table in the database. The stored procedure provides the count of rows, total reserved space, space occupied by the data, space occupied by Indexes and unused space.
Syntax:
SP_SpaceUsed
'
TableName
'
Databases
|
SQA
|
SQL Server
Thursday, February 12, 2009 11:46:10 AM (India Standard Time, UTC+05:30)
|
Akash Heranjal
|
Disclaimer
|
Comments [0]
|
Trackback
Related posts:
How to limit the data returned by each columns in a SELECT statement?
How to swap data between two columns of a table in SQL Server?
Smarter the better – SQL Server tips – part 03
Smarter the Better – SQL Server Tips – Part 02
How do I read excel file data columns as TEXT always?
Smarter the Better – SQL Server Tips – Part 01