Physical disk information with a single query? lets do it

Easy to do:

select bytespersector,Description,InterfaceType,Manufacturer,Model,Name,Partitions,PNPDeviceID,Sectorspertrack,Size,Totalcylinders,Totalheads,Totalsectors,Totaltracks,TracksperCylinder FROM Win32_DiskDrive
Results: