jansub07 (6/7/2012)
locations means different drives but same physical disk like c:\-MDF, D:\-LDF...How the performance exhibit difference..
Different partitions of the same drive? No advantage (performance or recovery) whatsoever.
That said, don't put data or log files on C drive. Windows gets very twitchy if the C drive fills up.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability