Viewing 15 posts - 3,781 through 3,795 (of 5,678 total)
Rog Saber (3/7/2011)
"However, just running the primary select statment just then took me 1:17 to return 14,765 rows. But, again, am I barking up the wrong tree...
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
March 7, 2011 at 9:49 pm
Jeff Moden (3/7/2011)
Kiara (3/7/2011)
But... but... it's *pretty*! I just wanted to look at it... really! We have such *boring* money over here in the States...
-Ki
BWAA-HAA!!! I will be happy...
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
March 7, 2011 at 7:43 pm
*facepalm* You're right, of course... what I get for untested code.
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
March 7, 2011 at 7:42 pm
So you're looking for something like this?
SELECT
t1.*
FROM
UnnamedTable AS t1
JOIN
(SELECT
[id],
MIN( times) AS mintime
FROM
UnnamedTable AS t2
GROUP BY
[id]
) AS drv
ONt1.id = t2.id
and t1.times = t2.mintime
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
March 7, 2011 at 3:45 pm
Thanks, so you're averaging about 8 rows of dates per combinations, ~12% of data... yeah, not enough to force the seek and lookup.
Hm, ~500 Car_inits...
Yeah, my apologies, but there's not...
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
March 7, 2011 at 3:42 pm
I just took a poke around the SSIS interface and in Data Flows found a tool that my eyes have glided over repeatedly... amazingly enough, called Pivot. 🙂
I have no...
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
March 7, 2011 at 3:25 pm
Alright, a little review of your multiple indexes show most of them have the same leading edge (trip_status), and then different incarnations of secondary seeking columns. Sadly, none of...
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
March 7, 2011 at 3:11 pm
Rich Yarger (3/7/2011)
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
March 7, 2011 at 2:41 pm
Rog Saber (3/7/2011)
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
March 7, 2011 at 2:36 pm
*facepalm*
Rich, introduce your Report Writer to the CREATE PROC command. He may love you forever... the rest of your developers... well... once you've taken Gail's advice, I live in...
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
March 7, 2011 at 2:07 pm
Rog Saber (3/7/2011)
No, I am just a developer w/ dbo. Maybe that makes a difference?
Yeah, you can't see what's happening in another spid unless you've got higher level access.
Have you...
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
March 7, 2011 at 2:03 pm
Note in cte that there's the ROW_NUMBER() component. Inside there, is the PARTITION BY. That Partitioning will control how it organizes the data. Take a look at...
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
March 7, 2011 at 1:54 pm
You only get one row when doing a select * from master..sysprocesses? You are SA on the system, right?
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
March 7, 2011 at 1:52 pm
Rog Saber (3/7/2011)
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
March 7, 2011 at 12:08 pm
I'm having a similar difficulty as Steve.
Are you looking to get a list of every entry in ems_cliente, and then get the counts as described by your where clause?
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
March 7, 2011 at 12:04 pm
Viewing 15 posts - 3,781 through 3,795 (of 5,678 total)