SQL Complex Queries , Query Optimization and Interview Questions SQLServer 2016

Описание

In above lecture new SQL Server 2012 - SQL Server 2016 TSQL features are covered. Eg:
1. Running total using SUM and OVER operator
2. Lead and Lag
3. First_Value and Last_Value
4. OFFSET and FETCH
5. IIF
6. Choose
7. Dense Tank
8. Interview Questions
9. Query optimization or Performance tuning
Link for script and backup file:
http://www.techsapphire.in/index/sql_complex_queries_query_optimization_and_interview_questions_sql_server_2016/0-190