Category Archives: T-SQL
-
Short circuiting an AND
2July 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 -
What permissions do temp stored procedures use?
3June 19, 2019 by Kenneth Fisher
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting …
Continue reading -
It’s interesting how an OR short circuits.
21June 17, 2019 by Kenneth Fisher
I recently did a post on the case expression short circuting and received a very very interesting comment from Chad …
Continue reading -
Does the case expression short circuit?
8June 13, 2019 by Kenneth Fisher
Let’s start with definitions: CASE Expression: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc …
Continue reading -
SQL Homework – June 2019 – Property functions
Leave a commentJune 3, 2019 by Kenneth Fisher
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This …
Continue reading -
I’m moving my permissions scripts to GitHub
2May 30, 2019 by Kenneth Fisher
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are …
Continue reading -
Using VALUES to construct an in-line table.
1May 22, 2019 by Kenneth Fisher
This has come up a few times recently, I find it rather fascinating and I can never seem to remember …
Continue reading -
How was it done back in the day? T-SQL Tuesday #114
2May 14, 2019 by Kenneth Fisher
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! …
Continue reading -
What version of SQL is SSMS scripting for?
Leave a commentMarch 25, 2019 by Kenneth Fisher
Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
Continue reading -
Mixed feelings over the new truncation error
2March 20, 2019 by Kenneth Fisher
As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
Continue reading
