An SQL syntax error is returned when the SQL query is parsed by the database engine. This is before any attempt is made to retreive any data from the database, so this error is not seek time related.
Now the slow file loading if being seen by everyone would be an issue with seek time.
If the database itself is fragmented, a disk defrag will not help that much since defragging the file the database uses does not defrag the data held in that file. That requires a database compress.
And while we’re in a mood to perform preventive maintenance, lets do some table re-indexing as well.
Guess who was a DBA in a former life.
You’re Hired… Free Fries on break there… [8D]
Fresh or Frozen?