I have been reviewing the code you provided, and was wondering how you then execute and delete the resultant package you have created? I am thinking that this may...

Also, i have a question :

when i write ml.year=2008, it´s because "2008" is a variable that iám introduced before running the script.

Do i must write the extended date like...

Geez,...

luissantos (4/28/2008)

---

Hello Lynn

thanks for your reply.

I test my tsql code with some index that you mencioned, but the maximum performance for this TSQL is about 6,30 minutes. Is too much

Also,...

Adam Bean (4/24/2008)

---

Same concept here ... scanning instead of seeking, no where clause, but on a join:

SELECT

NameType

,LastName

,FirstName

,MiddleName

,EndName

,NameKey

FROM tbl1 t1

INNER JOIN tbl2 t2

ON t1.NameKey = t2.NameKey

I've tried my index two ways:

CREATE...

rlondon (4/24/2008)

---

On one of my servers, when I do an sp_who2, I see that the LogWriter and Checkpoint processes are suspended. This is not a critical system with not...

I started looking at your query, and honestly, I gave up. You have a lot of subqueries that could be eliminated using joins in your FROM clause that would...

A trigger runs in the context of the transaction that fires it. If the trigger fails the whole transaction fails and rolls back.

I would have to agree with Steve.

😎

Found another WHERE clause that should be changed:

where year(ml.data)=2008

to:

where ml.data >= dateadd(yyyy,datediff(yyyy,0,ml.data),0) and ml.data < dateadd(yyyy,datediff(yyyy,0,ml.data) + 1,0)

This would use the index I suggested in my previous post as well.

😎

Here is my thoughts from a quick scan of your code:

If the following index does not exist, I would create it:

create index IDX_Balance on dbo.ml (

data...

Gail,

Thanks for jumping in on this and doing some testing. I tried to set up a test myself, but my mind wasn't working right and the test data I...

Steve F. (4/22/2008)

---

For the sake of argument, suppose I have a 10-million-record table with no index at all. The fields in this table include DataWeek (a smalldatetime; 10 unique...

I agree, check out all the products, and select the best one based on price, performance, ease of use, support, and what ever other criteria management might throw in. ...

On the free side, we are using gzip. It works well also. we are using it to zip text files prior to being ftp'ed to a MSP.

😎