Rog Saber (3/7/2011)

---

From my earlier post:

"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...

Jeff Moden (3/7/2011)

---

Kiara (3/7/2011)

---

BWAA-HAA!!! I will be happy...

*facepalm* You're right, of course... what I get for untested code.

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

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...

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...

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...

Rich Yarger (3/7/2011)

---

2. I actually did convert one of this reports with JOINS instead of the old school coding, but then one of my instructors told me that it wasn't...

Rog Saber (3/7/2011)

---

No, unfortunately, we really don't have an in-house DBA - hence my trying to get some insight here. We have a person that 'runs' things for us but...

*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...

Yeah, you can't see what's happening in another spid unless you've got higher level access.

Have you...

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...

You only get one row when doing a select * from master..sysprocesses? You are SA on the system, right?

Rog Saber (3/7/2011)

---

"Also, during the day, run this query and check the wait_state for the SPID and see what you get. It'd help to know why it thinks it's stuck....

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?