Does anyone know why SQL Server keeps taking up more and more memory and getting progressively slower as I perform more operations on it?
I run a stored procedure that creates 2 table (over 3000 records each). the first time I run the proc, it takes 20 - 25 seconds. By the 5th time I run it, it takes almost 3 minutes. Is there anything I can do to correct this?