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
What does the on delete cascade option do?
What is ms sql server reporting services?
How to maintain a fill factor in existing indexes?
Define model database?
Can a database be shrunk to 0 bytes, if not, why?
How to skip remaining statements in a loop block using continue statements?
Explain how you can deploy an SSRS report?
What is change tracking in sql server?
How real and float literal values are rounded?
How to stop log file growing too big?
What is the difference between a fill factor of 100 and 0?
How to store and query spatial data?
How can sql injection be stopped? : sql server security
what changed between the previous version of sql server and the current version? : Sql server database administration
Explain the benefits of user-defined functions?
