Hello Sir, its really great and I am fortunate to find something like this for a SQL DBA starter, please start a series on Performance Tuning with the below topics it will be very helpfull, Let me know if you have plans of starting any online paid course as well 1. Indexes and Index management 2. Compression level - rectifying improper compressions 3. Isolation levels 4. Partitions 5. Tuning Tools - Perfmon, Profiler and DTA 6. Updating Statistics 7. Extended Events Thanks a lot for your help. Hoping for a reply!!!
Hello man, God bless your efforts. I have a new question as a newbie. How shall i use the server optimizer in sql managemnt studio, is there any inbuilt settings or parameters to optimize the server, or is the server optimizer already configured to work optimally on my machine? Thanks a lot.