sqlserver-patterns

T-SQL query optimization best practices include using set-based operations, parameterized queries, and proper indexing strategies. This Skill provides guidance on query plan analysis and window functions to help avoid common performance pitfalls in SQL Server and Azure SQL Database.

Writing efficient stored procedures requires appropriate isolation levels, proper transaction handling, and parameterized queries. This Skill offers T-SQL patterns for error handling and schema design to ensure your stored procedures are secure, maintainable, and performant.

Yes, this T-SQL guidance covers SQL Server 2016+ and Azure SQL Database. It includes specific best practices for features like temporal tables, CTEs, and window functions across both platforms to ensure portability and optimal performance.

The best way to design a scalable SQL Server database schema is to follow robust design patterns and proper indexing strategies. This Skill provides recommendations for schema design, portability considerations between T-SQL and ANSI SQL, and temporal table usage.

Handling transactions in T-SQL requires proper transaction handling and appropriate isolation levels to maintain data integrity. This Skill outlines best practices for transaction management and error handling patterns to prevent concurrency issues.

You should use CTEs and window functions in SQL Server to write efficient, readable set-based operations instead of cursors. This Skill provides best practices for applying these features to optimize query performance and complex data analysis.