Dear Richard,

Nice Article. 🙂

If you can put more lines for Database Optimization,

would be more greatful for me.

My Company's present SQL database scenarios is as below.

Database Name: Buzz_Data

Database Size: 12.3 GB

Data Files: 1 (Primary)

Transaction Log File: 1

Database Tables: 500+

At Present my user's are facing problem to retrive data in time inspite of having Server's config like Intel XEON (IBM) , 2 GB Ram, 80 GB HDD.

Can you advice me to help my users.

Thanks, in anticipation.

Regards,

Ritesh Mehta

DBA

Gujarat (India)