Stored procedure was fine but then became extremly slow
96731
SQL Server: Query fast, but slow from procedure
148831
New database server hardware and software inserts slower than old setup
50874
SQL NVARCHAR and VARCHAR Limits
12427
Insert results of a stored procedure into a temporary table
76794
Stored Procedure doesn't exist, or does it?
146264
SQL Server Error 8632 due to over 100,000 entries in WHERE clause
28334
Initial connection to SQL Server Connection Is Slow. Why?
123192
SQL Server not using all memory
152542
Query extremely slow in code but fast in SSMS
57729
Simple way to programmatically get all stored procedures
79210
Stored Procedure with optional "WHERE" parameters
52453
Testing stored procedure scalability
34791
How can I retrieve a list of parameters from a stored procedure in SQL Server
102220
Table variable poor performance on insert in SQL Server Stored Procedure
77930
Which is better: Ad hoc queries or stored procedures?
139963
How to query More than 50000 records from sObject
11315
Select query takes more time than it should