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 grant a permission in ms sql server using "grant execute" statements?
How to use group functions in the select clause in ms sql server?
What is sql azure database?
Benefits of Stored Procedures?
What is a data source file?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to list all tables in the database using odbc_tables()?
How does normalization work?
How do I find the sql server instance name?
How to use user defined functions in expressions?
How to loop through result set objects using mssql_fetch_array()?
How to get a list of columns in a view using the "sp_help" stored procedure?
How you provide security to cube? : sql server analysis services, ssas
What is the beast way to write CTE in SQL Server ?
Can you leave a union at any time?