Tag Archives: best practices
-
All triggers have to be able to handle multiple row operations.
1September 3, 2020 by Kenneth Fisher
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
Continue reading -
Blogging and coding best practices
Leave a commentSeptember 25, 2019 by Kenneth Fisher
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. …
Continue reading -
Debugging techniques (focusing on T-SQL)
12September 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 -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
What’s the difference between Files and Filegroups?
2March 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
GDPR – After the restore
1March 19, 2018 by Kenneth Fisher
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading