Yes, well someone will have...

It looks like you've made a 20-25% reduction, which is pretty good, but still probably not nearly enough to change the big issues here.

It's under control panel; Administrative tools; Data Sources.

That is where it logs To: you can monitor all 30 servers and log them all to the same place if you want.

We probably can, if you do as I asked and follow the instructions in the linked article.

Glad I could help.

Please see this link for instructions on how to get better answers from this forum: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Waiting for the Original Poster to answer our questions...

Like this:

declare @businessdivisionID int

declare @zipcodes varchar(999)

declare @zipcodes1 varchar(999)

INSERT into #@retList

(source

,accountID

,ABINum

,companyName)

Select distinct 'account' as source

,a.accountID

,a.ABINum

,a.companyName

From...

Oops, we crossed replies...

Are you sure that you want to return every item in @Zipcodes times every item in @Zipcodes1?

It seems like what you really want is the UNION of those...

This smells like parameter-sniffing.

Just clarification:

bitbucket (9/5/2008)

---

The application role and control of same has changed from 2000 in 2005.

Reading from BOL it would appear that you set up logins for each user of the...

Alex, how did this work out for you? Can you give us an update?

mdean1962 (9/5/2008)

---

One thing that I've noticed is that not a lot of folks are aware that you start listing the tables in the FROM clause with the ones that will...