Hi river1

Strange question! Here's some help:

DECLARE @People TABLE(

FirstName VARCHAR(10),

SomeKey TINYINT PRIMARY KEY,

SomeForeignKey CHAR(1)

)

INSERT @People

SELECT 'Pedro', 1, 'A' UNION ALL

SELECT 'Pedro', 2, 'C' UNION ALL

SELECT 'Pedro', 3, 'A' UNION ALL

SELECT 'Martha',7,...

Tom West (4/8/2011)

---

My question is the best way to resolve it - I figure that if I put a separate index on ID2 this may help/resolve. My reservation with...

That's good to know, thanks for sharing the resolution and extra info with us 🙂

You'll have to setup some kind of polling mechanism if you want to know lock information over a time period.

Alternate query, using the new SQL 2005 objects

/*

sys.dm_tran_locks

http://msdn.microsoft.com/en-ca/library/ms190345%28v=SQL.90%29.aspx

*/

SELECT

spid =...

Maybe something to do with dynamic port and SQL Browser Service?

http://www.sqlservercentral.com/Forums/Topic448004-146-1.aspx#bm448007

Is there a firewall between you web and sql server?

hi tmiller

I'd be happy to help, do you think you could show a sample of the data and query the report is working with? You can use fictive data if...

Hi id

If I was certain that none of your field contain spaces I'd replace them with a separator and work my way up from there.

What do you think?

Maxim

Hi again Jake

I think it would be a great idea to divide the process into two parts. First populate a table with all the information from the runs and after...

It's worst :unsure:

I will be offline for a while, I check back later today hopefully with a different angle to look at this problem.

Seems legit to me, you can create various size implementations of SQL Server to accomodate the options in your list.

The stats seem up to date and in line with the data distribution you said earlier (10 run per race).

That nested loop appears to be the culprick but it's hard...

Looking at your questions I don't see any answers that would justify a certain DBMS over another.

Are you looking for a decision tree like:

If User > 300 --> DBMS1

If User...

dji (3/24/2011)

---

Your help is much appreciated. I am learning a lot along the way into the bargain.

The new execution plan is attached, took 59 seconds, that's 50 seconds quicker without...

Hi again

I suggest we chop this down to:

SELECT

*

FROM

dbo.MstRace

INNER JOIN

dbo.MstRun ON

dbo.MstRun.RaceID = dbo.MstRace.ID

LEFT OUTER JOIN

dbo.MstRace AS MstRaceP1 ON

MstRaceP1.ID = dbo.MstRun.PrvRace1

LEFT OUTER JOIN

dbo.MstRun AS MstRunP1 ON

MstRunP1.ID...

Hi jake,

Whats the difference between a race and a run? Is it a 1 to 1 relationship or do you have many runs per race?