Answer Posted / karthick.p
DBCC SHOWCONTIG - TO FIND THE FRAGMENTATION
DBCC SHRINKDATABASE - TO REDUCE THE SIZE OF THE DATABASE
DBCc SHRINK FILE - TO REDUCE THE SIZE OF THE FILE
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How to transfer an existing table from one schema to another schema in ms sql server?
what are the different ways to return the rowcount of a table?
How to use column default values in insert statements in ms sql server?
How to create median function?
How to backup encryption key ?
What is an entity-relationship diagram (erd)?
Which are new data types introduced in sql server 2008?
According to you what goes into making the best database administrator? : sql server database administration
Define left outer join?
List the different normalization forms?
Do you know the cursor optimization tips?
Why do we use trigger?
How is sql server used?
List out the differences between global and local temp tables in sql server?
What is stretch database in sql server?