SQL Server important links

• Joins

              https://www.techonthenet.com/sql_server/joins.php

• Indexes

              https://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/

• Index seek, scan, lookup and others in execution plan

              https://www.simple-talk.com/sql/performance/identifying-and-solving-index-scan-problems/

• Temporary tables vs table variables

              https://www.mssqltips.com/sqlservertip/2825/sql-server-temp-table-vs-table-variable-performance-testing/

• SARGable expressions

1. https://sqlsunday.com/2014/01/19/sargable-expression-performance/
2. https://datatellblog.wordpress.com/2016/11/24/sql-server-query-optimization-sargable-functions/
3. https://datatellblog.wordpress.com/2016/11/24/sql-server-query-optimization-sargable-functions/