If you’re lucky enough to have SQL Server 2016, go on and upgrade to SP1….you get extra-lucky special database snapshots in any version! Oh what’s that? You don’t use snapshots? Well let’s see a couple of good use cases for them.
Category: Tech and Learning
Why won’t my SP work THIS time?
Why won’t my SP work? I did this exact thing. You’re never too old to do something like this.
Step by Step: WHERE, GROUP BY, and HAVING
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the SELECT statement. The summary of each of these is simple to tell, but that doesn’t really sink in well, so we’ll walk through some examples.