13 September,2014 by Tom Collins
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.
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
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |