(Simon Sabin) Other than bad code plan stability is one of the main reasons for performance problems I see in client systems. This is often due to bad estimates, bad stats etc you can watch my SQLbits session on when a query plan goes bad for more information.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help