Viewing 15 posts - 46 through 60 (of 66 total)
Cheers Bob, I haven't seen that one before but it seems to work well:-D
April 29, 2009 at 2:39 am
Thanks Jetro but the subqueries reference a table called posts which is missed out in your version and so an error would occur
April 28, 2009 at 3:42 pm
Thanks guys, I was hoping that it was normal practise to restart on a weekly basis, but it looks like I'll have to try and diagnose the problem, or I...
April 27, 2009 at 3:34 pm
wiseman1982 (3/30/2009)
Give this a try to change handling of noise words:EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'transform noise words', 1
GO
RECONFIGURE
GO
Cheers, that seemed to do the trick, what's all that...
March 30, 2009 at 11:15 am
Hi Mike
It's a great article but I was hoping you could help me out with a problem that is driving me potty. :crying:
I implemented the code on my desktop machime...
March 30, 2009 at 8:41 am
Steve Jones - Editor (3/29/2009)
Out of curiosity, is this your main post table or something else?And which forum software do you use?
Yes this is the main post table and...
March 30, 2009 at 12:04 am
Krishna (3/29/2009)
I want to ask you something: What made you to ask this question?, I meant have you experienced any slow down on your server?
No, the forum part of the...
March 29, 2009 at 4:07 pm
GilaMonster (3/29/2009)
Check the index usage stats DMV for that info,
Thanks Gail, excuse my ignorance but how do I do that?:blush:
March 29, 2009 at 7:45 am
GilaMonster (3/22/2009)
Jeff Moden (3/21/2009)
[font="Arial Black"]E. Using DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database[/font]Or, since this is 2005, sys.db_db_index_physical_stats and ALTER INDEX ... REBUILD/REORGANISE
Okay I...
March 26, 2009 at 3:20 am
Alrighty, I've put in code to sop the parameter sniffing and that alone seems to have had a positive effect, I've also scheduled in a job to run in the...
March 21, 2009 at 5:32 pm
Jeff Moden (3/21/2009)
March 21, 2009 at 4:29 pm
I've taken the trouble to go through a number of indexes that were created by the tuning wizard and made some altercations here and there and there have been some...
March 21, 2009 at 10:19 am
GilaMonster (3/18/2009)
Matt (3/18/2009)
Matt, can you monitor for a couple days, when the query's slow check what the wait_resource and wait_time are. (sys.dm_exec_requests)
Okay, I'll do that and post the times up...
March 18, 2009 at 1:27 pm
I've found the perfect tool to use on the server to help me out, it's called a sledge hammer, it won't fix the problem but it will make me feel...
March 18, 2009 at 12:27 pm
GilaMonster (3/18/2009)
March 18, 2009 at 8:25 am
Viewing 15 posts - 46 through 60 (of 66 total)