Category Archives: Microsoft SQL Server
-
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 -
Database Permissions Queries
3August 5, 2013 by Kenneth Fisher
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
Continue reading -
Using DTEXECUI to generate a DTEXEC command line statement the easy way
8July 31, 2013 by Kenneth Fisher
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool …
Continue reading -
Notes on debugging Database Mail problems
10July 29, 2013 by Kenneth Fisher
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
Continue reading -
I’m going to my first SQL Saturday!
Leave a commentJuly 24, 2013 by Kenneth Fisher
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused …
Continue reading
SQL Studies 