Tag Archives: SSMS
-
Scripting a partitioned table or index, a caution.
14July 15, 2013 by Kenneth Fisher
I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
Continue reading -
Ordering steps in a SQL Agent job
2July 8, 2013 by Kenneth Fisher
Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
Continue reading -
Easy way to generate a restore script.
Leave a commentJune 5, 2013 by Kenneth Fisher
Easy way to generate a restore script. I was asked today if I had a canned restore script handy. I …
Continue reading -
Dragging a name from the object explorer to a query window
8May 13, 2013 by Kenneth Fisher
In the same vein as Steve Jones’ series on Customizing SSMS this is a fairly basic trick, but one that …
Continue reading -
Using Templates
3March 18, 2013 by Kenneth Fisher
Templates are one of those really handy tools that most DBAs I know of have either never heard of or …
Continue reading -
Multiple instances, single query window
2February 18, 2013 by Kenneth Fisher
Anyone who has been reading my blog for a while should realize that several divisions in my company have been …
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 -
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 -
Red errors in the results pane
3December 19, 2012 by Kenneth Fisher
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
Continue reading
SQL Studies 