network profile
| bio | website | verya.co.za |
|---|---|---|
| location | Johannesburg, South Africa | |
| age | 29 | |
| visits | member for | 1 year |
| seen | Dec 14 '12 at 7:56 | |
| stats | profile views | 5 |
|
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 |
comment |
Binding errors with dependent stored procedures I have only asked 4 questions hence the accept rate, one of which was only answered in the last day or so. The stored procs all use a temp table with the same name but if I understand it correctly because they are in different procedures they would create separate tables. I updated the initial post with more information DBCC FREEPROCCACHE seems to cause the problem to come back once you get it working by executing each dependent procedure. |
|
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 |
|
Oct 8 |
comment |
SQL Server Database Engine Tuning Advisor vs DMV queries Thanks for your response Aaron, I will take a look at Qure. If any database needs tuning it is this one I have started working on. I am excited that Qure does a lot more than just the indexes we have numerous stored procs that have problems too. |
|
Oct 3 |
asked | SQL Server Database Engine Tuning Advisor vs DMV queries |
|
May 30 |
comment |
Executing the query “UPDATE STATISTICS [dbo].[Contact] WITH FULLSCAN …” failed in-case anyone asks CHECKDB found 0 allocation errors and 0 consistency errors in database |
