Tag Archives: microsoft sql server
-
Detaching a database
1September 26, 2013 by Kenneth Fisher
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
Continue reading -
sp_DBPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
sp_SrvPermissions V2.0
1September 18, 2013 by Kenneth Fisher
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
Continue reading -
DBA Myths: You can’t use an alias in an UPDATE statement.
4September 16, 2013 by Kenneth Fisher
I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an …
Continue reading -
Certifications: What are they good for?
5September 11, 2013 by Kenneth Fisher
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and …
Continue reading -
A T-SQL query to get current job activity
30September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading -
When I run “Script as” it isn’t (or is) … How do I fix it?
1September 3, 2013 by Kenneth Fisher
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix …
Continue reading -
The effect of VLF size on shrinking the log.
3August 26, 2013 by Kenneth Fisher
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided …
Continue reading -
Lots of ways to UNPIVOT a table
Leave a commentAugust 21, 2013 by Kenneth Fisher
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
Continue reading
SQL Studies 