92 reputation
6
bio website verya.co.za
location Johannesburg, South Africa
age 29
visits member for 1 year, 10 months
seen Oct 24 '13 at 12:28

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
Nov
5
revised Database Indexing - Maintenance Jobs
edited tags
Nov
5
asked Database Indexing - Maintenance Jobs