-
What is the Object Explorer Details tab good for?
Leave a commentOctober 17, 2018 by Kenneth Fisher
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL …
Continue reading -
Highlighting sp_spaceused
Leave a commentOctober 15, 2018 by Kenneth Fisher
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
Continue reading -
Which is faster? IN (list) or IN (SELECT FROM Temp)
8October 11, 2018 by Kenneth Fisher
If you’ve done much with IN (list) then you’ve realized that it basically translates out to You’ve probably also realized …
Continue reading -
Letting the business bully you: T-SQL Tuesday #107
1October 9, 2018 by Kenneth Fisher
Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in …
Continue reading -
Generate a random number of children for each parent
4October 3, 2018 by Kenneth Fisher
I was asked an interesting question the other day. Is it possible to get a different random number of rows …
Continue reading -
SQL Homework – October 2018 – Time for an upgrade
Leave a commentOctober 1, 2018 by Kenneth Fisher
When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was …
Continue reading -
Data Types Word Search
4September 26, 2018 by Kenneth Fisher
Just for fun here is a word search with all of the data types available in SQL Server. Well, two …
Continue reading -
Escaping strings
Leave a commentSeptember 24, 2018 by Kenneth Fisher
No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom. …
Continue reading -
You can’t DELETE TOP (x) with an ORDER BY
8September 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
SQL Studies
Live, Learn, Share
