Category 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
3February 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 -
Deadlock priority
5February 8, 2017 by Kenneth Fisher
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
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 -
My SQL logins don’t work. Again.
Leave a commentJanuary 25, 2017 by Kenneth Fisher
My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one …
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 -
Lead Blocker
7January 18, 2017 by Kenneth Fisher
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and …
Continue reading -
Why won’t my SQL Logins work?
10January 12, 2017 by Kenneth Fisher
I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a …
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
