Viewing 15 posts - 4,921 through 4,935 (of 5,841 total)
Grant Fritchey (10/30/2008)
I'd add one more:5) Use the OPTIMIZE FOR query hint to get a plan based ona good parameter.
That still gets you a bad plan for "non-good" parameters. ...
October 30, 2008 at 7:32 am
I became aware reading your various posts that there was a language disconnect here, which is why I made this statement in my follow-up post: " A kajillion things...
October 30, 2008 at 7:25 am
Marios Philippopoulos (10/29/2008)
The best medicine for parameter sniffing (in my experience) is a "UPDATE STATISTICS tblName WITH FULLSCAN" on all (large) tables involved.
Actually update stats does nothing to address parameter...
October 29, 2008 at 4:34 pm
GilaMonster (10/28/2008)
rchantler (10/28/2008)
October 29, 2008 at 9:32 am
Scott, I really don't think that will help (and for more reasons than you missed the INSERT statement). 😀
Table variables cannot have any statistics against them, nor indexes. ...
October 29, 2008 at 7:41 am
As per the your post, I am not a fully DBA Person, But I have good holds on DBA commands. What I wanted to know from here is apart from...
October 29, 2008 at 6:59 am
quick lucky fixes can and do happen on this and other sites! It is just that the probability of 'quick' is inversely proportional to the size of the stuff...
October 28, 2008 at 10:52 am
What a mess! 😀 I can see why the optimizer can't get a good query! Not sure why you ask someone to review the code if you...
October 28, 2008 at 9:47 am
I wonder if it might not be a problem, even if it gets left on as the last statement by each spid connected. You will lose the ability for...
October 28, 2008 at 9:26 am
1) Sandy, you really need to get a perf tuning consultant to mentor you in how to investigate and correct sql server performance tuning issues. There are a kajillion...
October 28, 2008 at 9:23 am
1) You should take your current data size, figure out how much data space (including indexes) you will need 12-18 months from now, and make your database THAT BIG...
October 28, 2008 at 9:17 am
1) This issue has been going on for what, 18 days now? A phone call or internet chat to a good consultant would likely have had you operational in...
October 28, 2008 at 9:11 am
1) An exhaustive (and I mean VERY detailed) review of ALL code is the only way to determine what objects are/may be referenced.
2) If you don't already know where to...
October 28, 2008 at 9:02 am
Take a look in BOL for SET DATEFIRST. NOte that setting this inside sprocs causes a recompile event. Another possiblity is to store the start of the week...
October 27, 2008 at 9:13 pm
1) I am sure heaps have their uses, like other tools/options
2) speaking of options, I like having the ability to rebuild heaps in 2008!
October 27, 2008 at 8:50 pm
Viewing 15 posts - 4,921 through 4,935 (of 5,841 total)