-
You can’t DELETE TOP (x) with an ORDER BY
5September 19, 2018 by Kenneth Fisher
Did you know you can’t do this? Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword …
Continue reading -
How do I grant permissions to view users and their permissions?
1September 17, 2018 by Kenneth Fisher
tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions …
Continue reading -
Using Table Valued Parameters with sp_executesql
3September 13, 2018 by Kenneth Fisher
Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to …
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 -
I/O vs Logical I/O
Leave a commentSeptember 5, 2018 by Kenneth Fisher
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two …
Continue reading -
SQL Homework – September 2018 – Backup and Restore continued.
Leave a commentSeptember 3, 2018 by Kenneth Fisher
In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
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 -
Copying formatted text out of a grid column.
3August 27, 2018 by Kenneth Fisher
I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
Continue reading -
#SQLCareer 3/4 August 6th 2018
Leave a commentAugust 22, 2018 by Kenneth Fisher
Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database …
Continue reading -
Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties
3August 20, 2018 by Kenneth Fisher
Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
Continue reading
SQL Studies
Live, Learn, Share
