Also this is a great book to understand the fundamentals of SQL performance tuning. I'd recommend starting with it, then later getting a SQL Server-specific book if the tips you learn from it aren't enough:
The article does not discuss any performance particulars at all. I would suggest that the author buy and study the O'Reilly book SQL Tuning, which explains SQL query performance techniques in a database-neutral way.
https://smile.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Daps&field-keywords=sql+server+performance
Also this is a great book to understand the fundamentals of SQL performance tuning. I'd recommend starting with it, then later getting a SQL Server-specific book if the tips you learn from it aren't enough:
https://smile.amazon.com/SQL-Tuning-Generating-Optimal-Execution/dp/0596005733/ref=sr_1_1?s=books&ie=UTF8&qid=1491914487&sr=1-1&keywords=sql+tuning
The article does not discuss any performance particulars at all. I would suggest that the author buy and study the O'Reilly book SQL Tuning, which explains SQL query performance techniques in a database-neutral way.