Viewing 15 posts - 21,751 through 21,765 (of 22,189 total)
<ShamelessPlug>I just got an article published on the basics of performance tuning at Simple-Talk.com
http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/
</ShamelessPlug>
June 11, 2007 at 11:40 am
It might not be exactly what you're looking for, but have you looked into, what was in SQL 2000, the black box? Lookup sp_trace_create in BOL.
June 11, 2007 at 11:36 am
Something along the lines of:
SELECT c.State, h.HotelName, h.MinPrice
FROM City c
INNER JOIN Hotel h
ON c.City = h.City
AND h.Range = (SELECT MIN(Range)
FROM Hotel h2
WHERE h2.City = h.City
and h2.Hotel = h.Hotel
...
June 11, 2007 at 11:30 am
The estimated plan can't be trusted because statistics & data can get out of sync. I had to come up with a contrived situation to display it. Silly, I'll grant...
June 8, 2007 at 9:38 am
With some help from a person, here's one that works (by works I mean we get two different plans).
IF
EXISTS (...
June 8, 2007 at 8:55 am
The short answer is "as often as possible." What this translates to varies widely based on system, space, etc.. The reason is pretty much as you state. You need to...
June 8, 2007 at 4:36 am
It's funny you say that. The reason I posted an XML plan was that the graphical plans were acting all wonky with that script. There's a mystery I'm going to...
June 8, 2007 at 4:29 am
Basically, yes. I'm working on something and rather than simply caution that differences could arise, I'd like to show one.
June 7, 2007 at 10:21 am
Crud. Now parameter sniffing is taking part. If I take away the constant values & substitute a parameter I get clustered scans for everything...
**^& %^*%&% *%&$^& $*^%& ##%#!
And I...
June 7, 2007 at 8:31 am
I'm a little spacy this morning (production problems overnight), so maybe I'm doing something stupid here.
In desperation to try to find an answer this question, I hit up a...
June 7, 2007 at 8:13 am
Two identical plans:
<
ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.0"
June 7, 2007 at 7:07 am
Ha!
Well, I'm not going for messed up, but it's worth a shot. I'll let you know.
June 6, 2007 at 9:59 am
Everything the Guru said and, check the use of transactions in your process. Something seems to be doing some sort of lock escalation within the transaction because blocking, by itself, doesn't...
June 6, 2007 at 8:53 am
OK. Weak theory completely destroyed by reality. You can't drop statistics created by indexes and the other statistics just don't seem to be affecting the plan much. More ideas needed.
June 6, 2007 at 6:41 am
Something like this?
UPDATE Receipts
SET DateEnd = u.ExpiryDate
FROM UserRoles u
INNER JOIN Receipts r
ON u.UserId = r.UserId
WHERE u.RoleId = 5
June 6, 2007 at 6:39 am
Viewing 15 posts - 21,751 through 21,765 (of 22,189 total)