Query Tuning cannot be taught over forums

I comment on  forums as part of my daily routine. I’ve worked through different problem sets and find helping other people keeps my problem solving and research skills sharp.

I’ve observed a trend amongst forums with developers and DBAs attempting  to learn query tuning over a forum without possessing  the basic knowledge of SQL Server internals such as query processing , indexes and execution plans.

There are many forum posts asking for assistance in tuning a query and requests to teach query tuning.  Query Tuning cannot be taught over forums. Invest some time in reading some books , working through the problems offered in the books.  There are some great books available teaching internals and offering deep insights into SQL Server. Once you grasp the basics query tuning becomes significantly easier.

An important point for DBAs – bad coding is a primary source of many SQL Server performance issues. It is worth investing the time to master T-SQL  and is a fantastic investment in your DBA career.

Read More on developing as a DBA

Top 10 DBA Tips to develop your competitive edge - SQL Server DBA

DBA supertech . Specialise or generalise? - SQL Server DBA

SQL Server – DBA Skills Growth Areas

Professional Development and Soft Skills Training Books for the SQL Server DBA