Query Tuning cannot be taught over forums

13 September,2014 by Jack Vamvas

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


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Query Tuning cannot be taught over forums


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer