Tagged Questions
2
votes
2answers
812 views
SQL Server 2008 R2 Express size
I have what I believe is SQL Server 2008 R2 Express installed on a production server. When I connect to it with SQL Server Management Studio it shows up as SQL Server 10.50.1600.
If it is in fact SQL ...
3
votes
3answers
583 views
SQL Database size doesn't match with the total table sizes in the database
I have a database that is size about 104GB.
When I calculate the total table sizes in the database it's only about 24GB. This includes Data+index+unused spaces.
Why the DB size is too large?
4
votes
3answers
543 views
Recalculate row size in SQL Server 2008?
It is possible to recalculate row size in SQL Server 2008? Take this example:
declare @counter int
declare @statement nvarchar(max)
set @counter=0
drop table kua2
create table kua2(id int)
while ...
1
vote
2answers
1k views
Print database_size from sp_spaceused
Using SQL Server 2008, I have found that the database size can be obtained using
exec sp_spaceused
This procedure returns two tables:
database_name | database_size | unallocated space
reserved | ...
