Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Manila, Philippines
    Posts
    20

    Unanswered: Optimizing SQL Server

    Hello!
    We always Update, DELETE a record in the database. In ACCESS 2000, there is Compact and Repair database Utility. Just wnt to know the equivalent function in SQL server. And do we really need that also? How often we have to do that if there is any?

    Thanks for the time

  2. #2
    Join Date
    Dec 2003
    Location
    India
    Posts
    3

    Thumbs up Re: Optimizing SQL Server

    You can use DBCC SHOWCONTIG and DBCC SHRINKDATABASE commands.


    com
    Originally posted by bvmantos
    Hello!
    We always Update, DELETE a record in the database. In ACCESS 2000, there is Compact and Repair database Utility. Just wnt to know the equivalent function in SQL server. And do we really need that also? How often we have to do that if there is any?

    Thanks for the time

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •