Viewing 15 posts - 11,146 through 11,160 (of 22,214 total)
The function, is a multi-statement table valued function? If so, eliminating that may be the best bet for tuning the query.
To share a plan, save it as a .SQLPLAN file...
April 5, 2012 at 6:24 am
If you have really severe data skew, you need to evaluate it. Is the situation such that there are a few bad possibilities? If so, you can look to use...
April 5, 2012 at 6:17 am
You're doing JOIN to other views. That is one seriously problematic model. I strongly recommend against it. You're shooting the optimizer right in the foot before asking it to...
April 5, 2012 at 5:49 am
That's a very large topic. I have one chapter of my performance tuning book focused on the important metrics you need to collect. I really don't want to replicate the...
April 5, 2012 at 5:45 am
Stats get created any time a column is referenced in a WHERE or JOIN criteria. It doesn't necessarily mean anything.
I would take any and all suggestions from the DTA with...
April 5, 2012 at 5:43 am
Koen Verbeeck (4/5/2012)
Grant Fritchey (4/5/2012)
Yeah, I feel for him. I've had WAY too many arguments with people demanding that I rearrange the laws of physics because they said so.
If I...
April 5, 2012 at 5:30 am
Koen Verbeeck (4/5/2012)
SQLRNNR (4/4/2012)
GilaMonster (4/4/2012)
Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspxA lot of attitude on that one.
I think the attitude comes from a lot of frustration.
Yeah, I feel for him....
April 5, 2012 at 5:23 am
anthony.green (4/5/2012)
could you not create a secondary version of the...
April 5, 2012 at 5:21 am
I'd probably go with using extended events to audit the changes, but I can see how that might be difficult to see what's changed when, etc.
So, let's think outside the...
April 5, 2012 at 5:20 am
call.copse (4/5/2012)
April 5, 2012 at 5:10 am
Make sure your statistics are up to date is about your only option in SQL SErver 2005.
In 2008 or better you can start looking at filtered indexes, plan guides, other...
April 4, 2012 at 11:15 am
I don't understand the statement "not get anything in the execution plan." What are you expecting to get? The values in the execution plan regarding cost are only estimates based...
April 4, 2012 at 7:23 am
You just have to load it in smaller chunks and make sure your transaction log backups are running often enough (if the database is in FULL recovery). We use to...
April 4, 2012 at 6:05 am
Without setting up the tests, I can't tell you why. But... I can tell you where to look.
Check out both execution plans. In fact, you don't have to rerun the...
April 4, 2012 at 5:44 am
While that query is simple, as you've illustrated, the optimizer is probably going to be able to rearrange the structure so that you're getting a good clean JOIN. But, as...
April 4, 2012 at 5:38 am
Viewing 15 posts - 11,146 through 11,160 (of 22,214 total)