Problem The current environment is rather unique, with a unique workload that requires writing things like this. One of those being having the transactions cache on the server take up nearly 10 GBs of our memory. Being that we would like that 10 GBs of memory go towards the Buffer Pool
The Problem You have tables that have a lot of data inserted into them and deleted that use identity values and run out integers to use. I have over 3000+ databases where this can occur so we have an alerts setup that checks the tables then checks a table to
Wow, this year has been really busy. I’ve completely turned into a SQL Saturday addict with 15 SQL Saturdays completed, two more scheduled, and one more potential one to go. I might need an intervention or a 12-step program or I just may continue to have fun and meeting everyone