N/APosted on - 06/26/2012
For most installations, the only access to the SQL Server database is through the client program. This provides the essential database management services, such as backup and restore. However, system owners can be given SQL Server logins providing administrator access to the database using the Microsoft SQL Server client tools, such as Enterprise Manager and Query Analyzer.
Can SQL server performance be improved by defragmenting?
Yes, of course.
There are certain scripts which recommended by the professionals in the industry which you can use for defrag your SQL db. Since some of the data located in your DB is not actually required to run your system perfectly with improved performance, such tools can highlight and fix those errors with few clicks.
Also, you can manually authorize the changes and you can see how the performance progress.
However, don't forget to make backups of your system before you use such tools to defrag your base.