TSQL Programming Topics

• What is Collation is SQL Server and how it works
• GUID in Sql Server
• PIVOT, Multi Pivot & Dynamic Pivot in SQL Server
• Mutex in Sql Server
• Recursive CTE
• Bookmark lookup tipping point
• Conditional branching and OPTION(Recompile)
• Statistics used in the cached execution plans
• Pivoting with Python in Sql Server
• Temporary tables statistics when used in stored procedures
• Adding non-NULL value columns ONLINE
• ORDER BY – Changes everything
• Semi Joins, anti-joins and Nulls in Sql Server
• Three valued logic – NULL in Sql Server
• Short–Circuit evaluation in Sql Server