Web was slow but SQL Management Studio is fast.

Run this command on the database.

DBCC DROPCLEANBUFFERS 

DBCC FREEPROCCACHE