Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 11, 2024Best Practices: Why Changing SET Options Within a Batch in SQL Server is DiscouragedChanging SET options within a batch in SQL Server can lead to unexpected behavior, performance issues, and compatibility problems. It's strongly recommended to avoid altering SET options mid-batch for several reasons: 1. Plan Caching and Recompilatio...SQLAdd a thoughtful commentNo comments yetBe the first to start the conversation.