SQLStudies

7th Anniversary

• by Kenneth Fisher

• SQLStudies

7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading

2019-08-20

4 reads

Constructing a datetime from an integer date and an integer time.

• by Kenneth Fisher

• SQLStudies

Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading

2019-08-15

112 reads

When Have You Used MOT Tables? T-SQL Tuesday #117

• by Kenneth Fisher

• SQLStudies

Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading

2019-08-13

128 reads

Temporary stored procedures

• by Kenneth Fisher

• SQLStudies

tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading

2019-08-21 (first published: 2019-08-07)

173 reads

SQL Homework – August 2019 – Getting the data out

• by Kenneth Fisher

• SQLStudies

Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading

2019-08-16 (first published: 2019-08-05)

258 reads

Header Query Crossword

• by Kenneth Fisher

• SQLStudies

I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading

2019-07-31

43 reads

Optional vs Required parameters in Stored Procedures

• by Kenneth Fisher

• SQLStudies

If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading

2019-07-29

121 reads

Custom error messages

• by Kenneth Fisher

• SQLStudies

I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading

2019-07-24

17 reads

Current database vs database locks

• by Kenneth Fisher

• SQLStudies

I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading

2019-07-22

264 reads

Is it just me or does msdb feel a lot like a user database?

• by Kenneth Fisher

• SQLStudies

When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading

2019-08-07 (first published: 2019-07-17)

591 reads