In our product, I sometimes encounter the problem of dynamic IN-lists in SQL. First, they appear harmless, but soon they lead to an unnecessary amount of query plans. In this blog post I share how to circumvent those issues with TVP. A clean, performant and reusable way to solve this problem!
We store most of our application’s data in an SQL server database. Sometimes, we need to transfer the data locally to debug defects related to production data. The database grows daily, and restoring the database locally takes more and more time. So we had the idea to disable indices because they are not needed for debugging locally, but restoring them takes quite a lot of time. We can’t disable indices before exporting the data to a bacpac file because it’s the productive...