Tag Archives: problem resolution
-
Compressed backup errors and TF 3042
6March 16, 2017 by Kenneth Fisher
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
Continue reading -
Deadlock on ALTER DATABASE
5February 16, 2017 by Kenneth Fisher
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
Continue reading -
SQL Connectivity issues: A guided walk through
Leave a commentFebruary 6, 2017 by Kenneth Fisher
The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues. Announcement Walk Through If …
Continue reading -
Creating a connect entry.
4January 23, 2017 by Kenneth Fisher
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of …
Continue reading -
sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Leave a commentDecember 28, 2016 by Kenneth Fisher
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found …
Continue reading -
Altering a column in a large table: A case study
20July 14, 2016 by Kenneth Fisher
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
Continue reading -
Comparing the contents of two tables Redux
Leave a commentJune 8, 2016 by Kenneth Fisher
I did a post the other day on comparing two tables. It was meant as a general overview but I …
Continue reading -
Pulling data from a non-clustered index
1March 14, 2016 by Kenneth Fisher
This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
Continue reading -
‘Twas 4:45 Friday
Leave a commentDecember 23, 2015 by Kenneth Fisher
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
Continue reading -
“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
3October 15, 2015 by Kenneth Fisher
If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
Continue reading
