0

Does anyone know why SQL Server Express could be much faster that full SQL Server from VBA code? The difference is huge so I wonder if it could be in drivers? Thanks for your thoughts.

Community
  • 1
  • 1
Karel Bém
  • 97
  • 8
  • 1
    You'll need to be more specific to get much help. But for example is one on the local machine and one over a network? – PeterJ Dec 19 '12 at 00:29
  • 1
    SQL Server Express is the **same code base** as "full" SQL Server - so I would be extremely surprised if there were huge differences.... – marc_s Dec 19 '12 at 06:09

1 Answers1

1

That depends on many things. Is it running locally? Express is less demanding and probably will run better than a full fledged SQL Server install on your desktop.

Justin
  • 6,373
  • 9
  • 46
  • 72