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 are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Define self join?
How check triggers in sql server?
Explain view in sql server?
How to find the source of a table in sql server?
What are the indexes in sql server?
How to view the error log for any specific instance? : sql server database administration
In which files does sql server actually store data?
How can I track the changes or identify the latest insert-update-delete from a table?
Where actually sql azure database is hosted?
What are the advantages of using cte?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
what are the new features in SSRS?
how many no of arguments can be passed in procedures and functions
Why de-normalization required?