Monthly Archives: January 2013
-
Small changes, big effects
Leave a commentJanuary 30, 2013 by Kenneth Fisher
We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
Continue reading -
Model database
Leave a commentJanuary 28, 2013 by Kenneth Fisher
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & …
Continue reading -
IsMSShipped
3January 23, 2013 by Kenneth Fisher
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
Continue reading -
My view isn’t reflecting changes I’ve made to the underlying tables.
8January 20, 2013 by Kenneth Fisher
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. …
Continue reading -
Using New Horizontal/Vertical Tab Groups
9January 14, 2013 by Kenneth Fisher
This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently. …
Continue reading -
What port is my instance listening on?
8January 8, 2013 by Kenneth Fisher
I just had the interesting task of finding the port number that one of the instances I deal with is …
Continue reading -
How I like to learn a t-sql command
11January 7, 2013 by Kenneth Fisher
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands …
Continue reading
SQL Studies 