Category Archives: SQLServerPedia Syndication
-
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 most important skill to practice when preparing for any certification exam!
4August 28, 2013 by Kenneth Fisher
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
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 -
sp_SrvPermissions
Leave a commentAugust 19, 2013 by Kenneth Fisher
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
Continue reading -
“My transaction log is too big!”
4August 12, 2013 by Kenneth Fisher
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written, …
Continue reading -
How are COALESCE and ISNULL different?
6August 7, 2013 by Kenneth Fisher
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
Continue reading
SQL Studies 