Keep one thing in mind.

Cost of DBA/developer: $$/hr.

Cost of hardware $$$$/life of server.

The human cost can quickly exceed the box cost in trying to optimize/profile code. Not that it shouldn't...

tpantazi

Thanks for the references.

Steve Jones

steve@dkranch.net

no alias allowed.

yes you need a temp table

avoid this. Compute the sum yourself.

Steve Jones

steve@dkranch.net

patilds,

thanks for the referral. 🙂

Steve Jones

steve@dkranch.net

Be careful using a COM object from SQL Server, espeically if this proc gets used a lot.

Steve Jones

steve@dkranch.net

I agree with the two above. A couple items to think about.

1. As of right now, I have the decrpytion algorithm to decrpyt any v6.5 view/sproc/trigger. I also have 2...

MDAC should be it.

Steve Jones

steve@dkranch.net

Let us know and we can add it to our development efforts.

Steve Jones

steve@dkranch.net

Personally, it seems that not much is being said about AD all around. In fact, the last few .NET presentations I have seen haven't mentioned it at all.

Has anyone completed...

Clustered servers shouldn't give any help. Clustering is a fault tolerance, not a performance increase. The query executes on one box (still).

For partioned views, you get two types of...

I agree there isn't a good alternative. IMHO, it's poor practice to allow an application to log in without requiring a user to log in as well.

The only good solution...

Yikes, that could be a really large case statement. I'd look at some other method of handling this.

rgibbons: I used the @ symbol to give me something that wasn't used...

I think that other knuckclehead was Genghis Warren.

Glad you guys agree. This is one area that I think causes more problems than it solves.

I hate embedding logins...

Glad it will help. I've got some more details for how I handle the other side of the backups I will post soon.

Steve Jones

steve@dkranch.net

I tend to agree with Andy, though I dislike sharing boxes for 2 load intensive apps, especially for different clients or departments. They are always battling. In gerenal, however, you...