Viewing 15 posts - 4,831 through 4,845 (of 5,678 total)
It's all about the orders table. If you'll notice, the 'good plan' does a seek on the track index, then does a lookup and then does clustered seek against...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 5:42 pm
Frank Nadal (11/23/2010)
GRRR I highlighted the sql results and clicked on "plain" on the left and it still inserted those stupid faces. Sorry.
Don't worry about that as much. I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 4:41 pm
Iulian -207023 (11/23/2010)
I am sorry Chris I don't have the table structure at hand.Thanks,
Iulian
Need to see the build script and DDL to truly answer your question, or at least...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 4:21 pm
Frank Nadal (11/23/2010)
Yes yes. I'm looking at the graphical plan and the clustered index scan on that bad plan produced...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 4:19 pm
CREATE TABLE auData
(
auID NUMERIC, -- This column will have Unique value always
Emp_ID NUMERIC,
dt_Start DATETIME,
dt_End DATETIME,
Emp_Cat INT
)
Go
INSERT INTO auData VALUES(3037,1,'2010-11-18 11:36:34.210',NULL,1)
GO
INSERT INTO auData VALUES(3038,1,NULL,'2010-11-18 11:49:00.917',1)
GO
INSERT INTO auData VALUES(3039,1,'2010-11-18 15:15:04.590',NULL,1)
GO
INSERT INTO auData...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 4:14 pm
Of note:
| |--Clustered Index Seek(OBJECT[WINTRACK_NLA].[dbo].[orders].[ORDERS_PK_C] AS [o]), SEEK[o].[o_num]=[t].[o_num]), WHERE(Convert([o].[o_type])=30 OR Convert([o].[o_type])=9) AND ((([o].[trn_id]=0 OR [o].[trn_id]=25
| | |--Clustered Index Scan(OBJECT[WINTRACK_NLA].[dbo].[orders].[ORDERS_PK_C] AS [o]), WHERE(Convert([o].[o_type])=30 OR Convert([o].[o_type])=9) AND ((([o].[trn_id]=0 OR [o].[trn_id]=25) OR [o].[trn_id]=45)...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 4:02 pm
Heh, to make life easier, can you edit that post and wrap the plans in the code="plain" shortcuts you'll see on the left? Just highlight the section and click...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 3:59 pm
Alvin Ramard (11/23/2010)
CirquedeSQLeil (11/23/2010)
Alvin Ramard (11/23/2010)
Stefan Krzywicki (11/23/2010)
Craig Farrell (11/23/2010)
Stefan Krzywicki (11/23/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 3:33 pm
It's rare to get a serious issue still in the 2k environments, so to confirm, you meant to post in the SQL 7/2k forum, right? If so, which are...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 3:28 pm
Alvin Ramard (11/23/2010)
LutzM (11/23/2010)
Alvin, that's what you look like when you've had time to shave?!? 😀But isn't that counterproductive regarding hunting season?
Depends on what I'm hunting. 😎
My word, Alvin......
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 3:23 pm
GSquared (11/23/2010)
Roy Ernest (11/23/2010)
You all have a wicked sense of humor... 😀
No, I don't. We've already agreed on that. (Of course, the very statement that I avoid humor...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 2:01 pm
GSquared (11/23/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 1:54 pm
GSquared (11/23/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 12:26 pm
Stefan Krzywicki (11/23/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 11:56 am
CirquedeSQLeil (11/23/2010)
Alvin Ramard (11/23/2010)
CirquedeSQLeil (11/23/2010)
GilaMonster (11/23/2010)
CirquedeSQLeil (11/23/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 23, 2010 at 11:14 am
Viewing 15 posts - 4,831 through 4,845 (of 5,678 total)