Latley we're having some strange behavior in some large databases. Sometimes the queries just takes a long time to run. They've run fine earlier. Is there a limit in rows/data that one should stribe to not exceed? It's on a fast machine with almost 12Gb free space. One table e.g has 1126320 rows. The database in question takes up 1845 Mb after a shrink logs. I'm not sure if trunkating the large tables or remove tables not beeing used would be best. Greatful for any input.