Viewing 15 posts - 6,166 through 6,180 (of 18,926 total)
chandan_jha18 (5/13/2011)
Ninja's_RGR'us (5/13/2011)
You are right. Once you create that index, the optimizer will then use that one and possibly suggest...
May 13, 2011 at 5:44 am
Permission denied means exactly that... can't access the file. Not much else to add to that one.
May 13, 2011 at 5:27 am
Ya 1 point definitely underkill for this one.
Maybe Steve's MCM training has skewed his judgement a little bit... you're getting too good Stevie! :hehe:
May 13, 2011 at 5:25 am
For self-service on wait stats >>>
http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Post back with more info and the specifics where you need help.
May 13, 2011 at 5:23 am
I had 30 seconds to download / analyse the plan.
You are right. Once you create that index, the optimizer will then use that one and possibly suggest a better...
May 13, 2011 at 5:20 am
I don't know that any book has ever been written to adress only or such a specific issue.
The book I had in mind with grant was just solid info about...
May 13, 2011 at 5:17 am
chandan_jha18 (5/13/2011)
Ninja's_RGR'us (5/12/2011)
Mike01 (5/12/2011)
That guy wrote a statement like
Update dbo.Transactions Set
TractorPPG = @price,
TractorCost = @TotalCost
Where Current OF OPIS_Cursor
do you think any index will help here as this...
May 13, 2011 at 2:50 am
Then you don't need to check the logs at all.
The script I provided an be adapted to warn for 70%.
The only snippet missing is the sendmail which I can provide...
May 13, 2011 at 2:47 am
Awesome!
MM rules :w00t:
May 12, 2011 at 5:06 pm
You could always use a stored prod and do something like this...
Either use format only or parse only (never used that one so not sure what it does or how...
May 12, 2011 at 3:20 pm
Why can't you call it form within the app and not sql server?
May 12, 2011 at 11:28 am
opc.three (5/12/2011)
GilaMonster (5/2/2011)
All tables should have a clustered index (with a few specific exceptions)Not to hijack the thread or anything...but what is your list of specific exceptions?
I forgot the exact...
May 12, 2011 at 11:23 am
RimonTL (5/12/2011)
Could you please elaborate more on how you spotted that fillfactors need to be changed and which portion of her code helped you to do it?Thanks.
I let the code...
May 12, 2011 at 10:53 am
Stop stressing for 2 seconds.
Setup a test environement, do inserts, updates, deletes and see the execution plan. You'll know the exact impact on your system and you'll know...
May 12, 2011 at 9:07 am
Viewing 15 posts - 6,166 through 6,180 (of 18,926 total)