Tag Archives: problem resolution
-
Debugging techniques (focusing on T-SQL)
13September 23, 2019 by Kenneth Fisher
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: …
Continue reading -
Why is as important as How
6August 28, 2019 by Kenneth Fisher
I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so …
Continue reading -
Why am I getting an NT AUTHORITY\ANONYMOUS error when creating or altering a stored procedure?
1May 8, 2019 by Kenneth Fisher
If you have to deal with linked servers then you probably have or will run into the following error: Login …
Continue reading -
What happens in a trigger stays in the transaction: T-SQL Tuesday #106
Leave a commentSeptember 11, 2018 by Kenneth Fisher
Anything that happens in a trigger happens within the same transaction of the command that called it. Part of me …
Continue reading -
SQL Puzzle: Advent of Code
Leave a commentAugust 29, 2018 by Kenneth Fisher
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
Continue reading -
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Leave a commentAugust 14, 2018 by Kenneth Fisher
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started …
Continue reading -
Processes can dramatically improve your work until they don’t.
Leave a commentJuly 23, 2018 by Kenneth Fisher
As always with something like this, I like to start with a definition so we are all starting in the …
Continue reading -
Interview questions: What’s the first thing you would do if a user reports slowness.
8May 28, 2018 by Kenneth Fisher
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do …
Continue reading -
The trials and tribulations of REVERTing from impersonation
1May 16, 2018 by Kenneth Fisher
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
Continue reading -
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading
SQL Studies 