One common issue that bugs me is where databases have been moved from one instance to another, usually through backup and restore, and the files haven’t been moved as part of the restore so they get recreated in the data\log folders for the old instance.
This has caused me various problems, e.g. working out which instance is hammering the disk or using up all the space.
Click through for the script.