I just recently configured a brand-new Windows SBS 2008 Server with SQL 2008.
The box is a HP Proliant DL 380 G5 with 32GB RAM and a 250GB SSD.
I have Access97 as a front-end and using ODBC I connect to SQL Server databases via linked tables. Actually does work very well.
After the initial install, SQL performance was stellar. Then, after doing a Windows Update and installing many updates, the SQL performance dropped terribly. It seems to me an update has caused an issue.
Does anyone know of key updates that might compromise the SQL performance?