Monthly Archives: July 2019
-
Header Query Crossword
Leave a commentJuly 31, 2019 by Kenneth Fisher
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this …
Continue reading -
Optional vs Required parameters in Stored Procedures
13July 29, 2019 by Kenneth Fisher
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain …
Continue reading -
Custom error messages
1July 24, 2019 by Kenneth Fisher
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem …
Continue reading -
Current database vs database locks
2July 22, 2019 by Kenneth Fisher
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is …
Continue reading -
Is it just me or does msdb feel a lot like a user database?
Leave a commentJuly 17, 2019 by Kenneth Fisher
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to …
Continue reading -
Short circuiting an AND
4July 15, 2019 by Kenneth Fisher
The other day I did a post on how an OR short circuits. It was a somewhat unusual type of …
Continue reading -
Learning Powershell with Show-Command
4July 11, 2019 by Kenneth Fisher
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. …
Continue reading -
SQL Homework – July 2019 – Table Size
Leave a commentJuly 1, 2019 by Kenneth Fisher
In general this homework series is meant to give you ideas of things to play with that most if not …
Continue reading
SQL Studies 