92 reputation
8
bio website verya.co.za
location Johannesburg, South Africa
age 30
visits member for 2 years, 5 months
seen Oct 24 '13 at 12:28

Jul
2
awarded  Curious
Jun
2
awarded  Popular Question
Aug
27
awarded  Supporter
Aug
27
accepted SQL Analysis Services - SSAS
Aug
27
accepted Executing the query “UPDATE STATISTICS [dbo].[Contact] WITH FULLSCAN …” failed
Aug
27
accepted Binding errors with dependent stored procedures
Dec
5
awarded  Teacher
Dec
5
answered Binding errors with dependent stored procedures
Dec
5
accepted Database Indexing - Maintenance Jobs
Dec
5
answered Database Indexing - Maintenance Jobs
Dec
5
accepted SQL 2008 RTM Temp Tables
Dec
5
comment SQL 2008 RTM Temp Tables
Thanks I will continue to monitor the number of tables, the app seems to have about 300-400 at any given time in our Live Environment. Will also look at dumping the temp table info as indicated below.
Dec
5
awarded  Scholar
Dec
5
awarded  Editor
Dec
5
revised Binding errors with dependent stored procedures
added 248 characters in body
Dec
5
awarded  Cleanup
Dec
5
revised SQL 2008 RTM Temp Tables
rolled back to a previous revision
Dec
5
asked Binding errors with dependent stored procedures
Nov
30
comment SQL 2008 RTM Temp Tables
I dont think it is caused by our monitoring solution because that simply selects from sys.dm_os_performance_counters. At about 1 AM this morning all the temp tables were cleared and at about 6AM when the users started testing again the count started increasing.
Nov
29
asked SQL 2008 RTM Temp Tables