Monthly Archives: November 2017
-
SQL Puzzle – Word Scrambler
2November 29, 2017 by Kenneth Fisher
I’ve been writing crosswords for the last few months and to change things up I thought I would do a …
Continue reading -
Closing all of the connections to a database
4November 27, 2017 by Kenneth Fisher
Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
Continue reading -
Why shouldn’t I shrink my database data file?
3November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
Continue reading -
Variables in Dynamic SQL
4November 16, 2017 by Kenneth Fisher
I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
Continue reading -
It takes a village
1November 14, 2017 by Kenneth Fisher
Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten …
Continue reading -
More Collation Confusion. (tempdb)
1November 8, 2017 by Kenneth Fisher
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
Continue reading -
DBA Definitions: FILLFACTOR
1November 6, 2017 by Kenneth Fisher
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
Continue reading -
SQL Homework Nov 2017: Create a view
3November 1, 2017 by Kenneth Fisher
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
Continue reading
SQL Studies 