Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain some DBCC commands?

Question Posted / karthick.p

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


Please Help Members By Posting Answers For Below Questions

Can an automatic recovery be initiated by a user?

1066

Can we call stored procedure in view in sql server?

940

What are system databases in ms sql server?

1124

What is normalization and denormalization in sql server?

1063

What is the difference between mysql and mysqli?

1286

wat wil hapn if we give the both read and deny read permission to user?

2151

What is Lock table in SQL?

1519

Write a code to select distinct records without using the DISTINCT keyword.

1183

What are pages and extents? : SQL Server Architecture

1071

What does Master database contains?

1180

Explain the different types of backups available in sql server? : sql server database administration

986

What are different types of data sources?

1081

What is wrong with sql server client libarary dll, ntwdblib.dll?

1092

What is a field in a table?

1070

What are a database and a data warehouse?

1072