Musings, code and other stuff....
Sign in
Home
Archive
Contact
Subscribe
<< The difference between TRUNCATE and DELETE in a SQL table
|
Find the name of the SQL server a stored procedure is running on >>
Find the physical size on disk of table within a database
Tags:
SQL
,
Database
| Categories:
Knowledgebase
Posted by
Ian Blair
on 2/26/2011 8:55 AM | Comments (0)
To find out how much physical disk space a table takes up execute the following stored procedure.
EXEC sp_spaceused N'[TableName]'
This will return the following information.
Name, Rows, Reserved, Data, Indexed Size, Unused
Permalink
|
Comments RSS
Share it:
E-mail
|
Kick it!
|
DZone it!
|
del.icio.us
Related posts
Find the path(s) to the SQL database server in CRM
A while ago I was faced with the problem of finding the SQL server and database name for a UAT CRM i...
The difference between TRUNCATE and DELETE in a SQL table
There are two methods to do this either using a TRUNCATE or DELETE command. Both have their adv...
Select random records from a SQL table or view
A quick way of selecting a batch of random records from a SQL table is to include the NEWID() functi...
Comments are closed
We do IT, development, crm consultancy and other stuff.
Search
Include comments in search
Month List
2011
February
(7)
March
(1)
Tag cloud
CRM
Database
JavaScript
SQL
Stuff
Twitter
July 12. 15:31
Multitasking - Monitoring the #MSCRM to Terms golive and building a #CRM link to Streetdoctor.
July 11. 17:57
It doesn't matter how much you test in uat, live is always a different animal.
July 11. 15:36
Last minute change to TERMS integration with #MSCRM before system gets its first real workout tomorrow. Change control overriden by client!
July 8. 09:49
At the end of the day its all about eyeballs. If nobodys looking nobodys buying......
June 24. 20:28
Not 1 but 2 successful go-lives in one week. Damn I'm good lol.
Follow me on Twitter