Interested to Buy Any Domain ? << Click Here >> for more details...
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 many no of arguments can be passed in procedures and functions
What are data files?
What is trigger explain with program?
What are the pre-defined functions in the sql server?
What is ms sql server triggers?
What is model database? : SQL Server Architecture
How to stop a loop early with break statements in ms sql server?
Explain the database you used in your final year project?
What is raid? : SQL Server Architecture
What is the difference between migration and upgradation in sql server?
What is a db view?
What is BCNF? How is it better than 2NF & 3NF?
When I delete any data from a table, does the sql server reduce the size of that table?
What is lock escalation and what is its purpose?
How can you check the level of fragmentation on a table?
