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.

😎

Based on what I have read regarding Microsofts licensing, nope. With that number of users, per processor is the best way to go.

😎

Not really, substitute the pricing for EE (approx $25K per processor), or for Oracle (I don't even feel like computing that).

The key to deciding whether to purchase per processor or...

Looks good to me.

😎

Microsoft goes by physical processor, not cores, so your server has 4 processors.

😎