Tag Archives: problem resolution
-
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
21July 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
2March 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 -
Finding the error from a failed job.
5October 7, 2015 by Kenneth Fisher
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say …
Continue reading -
“sql_handle” is not a recognized table hints option.
Leave a commentSeptember 23, 2015 by Kenneth Fisher
I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
Continue reading -
The 30 minute rule
9August 26, 2015 by Kenneth Fisher
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
Continue reading -
Pulling data from the error log
8August 17, 2015 by Kenneth Fisher
The other day I was asked to pull a list of errors from the SQL Server log into a table …
Continue reading
SQL Studies 