Viewing 15 posts - 14,146 through 14,160 (of 19,562 total)
A solution that I have implemented is to run a trigger that inserts the data for all running stored procedures into a log table. The trigger was a logon...
May 7, 2010 at 11:06 am
Angelindiego (5/7/2010)
Thank you all for the ideas, I am trying them all!!!!!!!!!!
You're welcome.
May 7, 2010 at 10:58 am
GilaMonster (5/7/2010)
I've added it to my 'list of topics to blog on'. Thanks, the list was getting a little short now that I've finished with in, exists and joins.
That should...
May 7, 2010 at 10:57 am
Ahh. I saw the thread asking about good Universities but didn't open it up.
Thanks Gail.
May 7, 2010 at 10:55 am
If it is still growing, I am going to re-recommend performing that routine outlined in the article I suggested. There is another query that is causing growth.
May 7, 2010 at 10:53 am
Lynn Pettis (5/7/2010)
CirquedeSQLeil (5/7/2010)
GilaMonster (5/7/2010)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.
Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???)...
May 7, 2010 at 10:51 am
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
I can see the...
May 7, 2010 at 10:47 am
GilaMonster (5/7/2010)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
You and me...
May 7, 2010 at 10:33 am
GilaMonster (5/7/2010)
CirquedeSQLeil (5/7/2010)
May 7, 2010 at 10:31 am
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
Nah - not rude.
I'm...
May 7, 2010 at 10:28 am
Brandie Tarvin (5/7/2010)
CirquedeSQLeil (5/7/2010)
May 7, 2010 at 10:24 am
You can also take a look at sys.dm_exec_query_stats. You will need to know the sql_handle for the query you are running though. You would want to look at...
May 7, 2010 at 10:21 am
Run this query and post the results
SELECT top 5 *
FROM sys.dm_db_session_space_usage
ORDER BY (user_objects_alloc_page_count +
internal_objects_alloc_page_count) DESC
May 7, 2010 at 10:08 am
It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and ask them...
May 7, 2010 at 10:06 am
Viewing 15 posts - 14,146 through 14,160 (of 19,562 total)