Find Stored procedure which are using temp tables
8662
Is there a way to do a textual search through all stored procedures for a table name?
151604
Why does a query run slower in a Stored Procedure than in the Query window?
136183
Get all dates in date range in SQL Server
142750
Using INSERT INTO...EXEC AT linked server into temp table fails with Msg 7391
142158
SQL Server TempDB behaviour in large memory environment
784
Recommendations for more than one tempdb file
79210
Stored Procedure with optional "WHERE" parameters
50702
Run stored procedures in parallel
52453
Testing stored procedure scalability
44488
Execute stored procedure in OUTER APPLY block
128783
How to save select query results within temporary table?
114214
How do I find records that are not joined?
73090
Execution sequence of Group By, Having and Where clause in SQL Server?
158997
In MS SQL how do I find out what tables have not been queried or updated in a long time?
151309
Identifying Unused Stored Procedures
14582
How to identify which query is filling up the tempdb transaction log?
61886
How to view an encrypted view or stored procedure