title: Can adding basic new SQL Server index create more problems?
body: <p>I'm completely new to Indexing and would like to speed up some of my customers systems. My organisation made a mistake and upgraded a few of our customers from SQL Server 2000 to SQL Server 2008 before testing it fully in-house. The (new) servers are running slower than ever before as result. This is baffling the customers as you can imagine. Each customer has a two SQL Server user databases set up both about 1GB in size and each customer has about 30 users each.</p>
  
  <p>At my organisation, there are not any currently resources to bring in a Developer or DBA to recommend what to do to speed up the new systems in place.</p>
  
  <p>If I were to spend say four weeks learning as much as about SQL Server databases and indexes, do you think it might be a good idea to add some indexes to see if this makes any difference? Also could I easily delete the Indexes to put the system back the way it was so no harm done? Apart from it being a learning experience?</p>