I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.
Month: September 2017
SQL Server: The danger of large data types
Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.
Offtopic: Lifehack: Old tech has many purposes
For those that don’t know, I live in Texas. Been here all my life. There are two main things north Texans worry about from mother nature: Tornados & Hail.
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.
Thank you for Microsoft MVP
My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification. At first I thought it was spam and then I did a double take.