No, there is a 2 byte overhead in the variable-length column offset array for the VARCHAR(1) datatype as explained by Paul here: [http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-record/][1] [http://www.sqlskills.com/blog...

You can use the restorhistory and backup tables in msdb to do this like this:

SELECT
destination_database_name,
server_name AS 'SourceServer',
database_name AS 'SourceDB',
physical_device_name,
t...

This is a first of what is planned to be a weekly list of top blog posts on topics important to being a SQL Server DBA here.  I first want to give a big thanks to Jacob Sebastian for offering ...

This is a first of what is planned to be a weekly list of top blog posts on topics important to being a SQL Server DBA here.  I first want to give a big thanks to Jacob Sebastian for offering me the opportunity to contribute here, and provide a wee...