Tagged Questions
1
vote
3answers
221 views
Big size of database logs SQL Server 2008
I have a database which is running under Microsoft SQL Server 2008. Now, I have seen that the log of the database (the .ldf file) is growing to big size. The database file (.mdf) has a size of 630MB ...
4
votes
3answers
559 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 | ...
