Syntax to find the used space and free space of the Data
file in a database(SQL Server). Following queries didn't
give the exact Used space and Free Space Information
sp_spaceused;DBCC showfilestats;exec
MyDbName.dbo.sp_spaceused;SP_HELPFILE
Can any one tell me the query for how to find the exact
used data file space and free space in a Data File?
Answer Posted / allah baksh
exec sp_spaceused [schema.tablename] this will give you
data file and the size available
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does the order of columns in update statements matter?
What is rtm version in sql server?
What is 1nf normalization form?
How do you know if sql server is running on your local system?
Are semicolons required at the end of sql statements in sql server 2005?
Where are sql server user names and passwords stored in sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What are window functions in sql server?
How can you find out how many rows returned in a cursor?
What is the name of reporting services config file and what’s it’s used for?
How many columns can we include on clustered index ?
Is it important for a database administrator to understand the operating system and file access?
What is the default port for SQL Server over a firewall?
what is the difference between count(*) and count(1) ?
What are translations and its use? : sql server analysis services, ssas