Viewing 3 posts - 1 through 3 (of 3 total)
So which is really better - the very clever one-liner whose logic can't be unravelled without some head scratching, or the somewhat longer version that's simple enough to be self-explanatory?
[font="Courier...
October 13, 2011 at 5:59 am
Curious that Steve's question was about efficiency rather than effectiveness. It reveals, I believe, an institutionalized bias in favor of speed over quality. After 30ish years as analyst/designer/developer/DBA/Informaticist (don't ask,...
October 22, 2010 at 8:28 am
Hmm, why not this?
use msdb
select
database_name
from
backupmediafamily f
inner join backupset s on s.backup_set_id = f.media_set_id
where
physical_device_name = 'backupDB_db_200805050856.BAK '
May 5, 2008 at 5:59 am
Viewing 3 posts - 1 through 3 (of 3 total)