Building up a mental model of how locking and transaction isolation levels work in Microsoft SQL Server.
Read MoreTemporal tables are a useful feature introduced with SQL Server 2016 to track changing data. Here I show a quick example of converting existing data to temporal tables, I show another subtle trick to implement an automatic "modified date" without a history table, and I demonstrate some possible pitfalls with the temporal table behavior.
There are a lot of performance best practices with Microsoft SQL Server that can add up to a significant impact; some of them involve the machine, some of them involve Windows. Some of them involve the SQL server instance, and some of them involve the database: many of the defaults when setting up a new SQL instance and database are suboptimal, probably for legacy reasons. (Thankfully, SQL 2016 finally improves all this!)
I've collected as much as I can here into a "one stop shopping" checklist. And you can always contact us for help!
Read More