My company has recently requested that all our developers gain knowledge and experience using SQL server database’s (as opposed to sitting in VS all day long). We are all using SQL Server EXPRESS 2008 R2 and everyone else seems to be running the setup just fine.
With me however, lies the problem. When running any kind of command it takes a very long time, to give you an example a stored procedure executed on a colleagues PC took 4 seconds, for me 7 minutes!
Of course before posting here I did a fair amount of research into the problem, I’ve tried running a disc defrag, MSDN trouble shooting and even completely reinstalling the program all with no change. When running a query with the resource monitor open I can see that SQL cpu image ssms.exe will run for afew seconds then not respond for a good few minutes, run another few seconds and repeat until the query is complete.
MY question is does anyone have any form of solution to this or perhaps a better idea of the problem?