SQL Server SSD vs HDD performance -
so i'm doing performance comparison between ssd , hdd sql server insert statements. i'm inserting 2,000 columns worth of data across 4 different tables. for each record insert 1 row in each table. i tested on 1 machine ssd main hard drive running sql server process , database file on secondary hdd drive. i tested on machine ssd drive has both sql server process , actual db file. i have expected machine database field on hdd slower machine on ssd. is behavior i'm seeing expected? if why?