Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating joins, and sometimes slow down DML operations (inserts, updates, and deletes).
I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One thing that I’ll always remember is my first day at Microsoft and not because I found out that health care was 100% free; though, that was a pleasant shocker. During New Employee Orientation (NEO), the trainer asked who had spouses that worked here and also who had worked here before.
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details are as follows:
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface Pro 3 dev instance about every 30 to 60 seconds.
I opened object explorer to check if any jobs were running in SQL Agent that may be running DBCC FREEPROCCACHE