193 Views
It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high...
Transaction log files are sequential access only, so multiple files will not improve performance.
Sorry about the confusion on my part, it's Monday ;-)