The effect of VLF size on shrinking the log.
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided...
2013-08-29 (first published: 2013-08-26)
2,635 reads
SQLStudies
Lots of ways to UNPIVOT a table
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...
2013-08-21
1,331 reads
sp_SrvPermissions
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...
2013-08-19
1,487 reads
sp_DBPermissions
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,519 reads
“My transaction log is too big!”
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,666 reads
How are COALESCE and ISNULL different?
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...
2013-08-16 (first published: 2013-08-07)
8,904 reads
Database Permissions Queries
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,443 reads
Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,741 reads
Notes on debugging Database Mail problems
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,415 reads
I’m going to my first SQL Saturday!
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
665 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers