In that case, I would say you have another problem, possibly with concurrency, and are seeing its simptoms here as well. Trace back just prior to the networkio waits, and...

LMAO.......Andy is also a good comedian........

From what I've seen, it comes down to management, as stated. The main issues I've seen in this area boils down to the development guys...

I see what your saying. And your correct. And I realize such things are outside the control of the dba at times. The thing about it though, is that it's...

Sorry, Lee Dise, but I disagree on the triggers. The joining of the before and after pseudo tables is done on the primary key in any case, and you will...

Sounds like to me it will still work. Just inner join the third table along with the statement suggested, but do not include any fields in your result set from...

I wrote an article on waitstats. It's at

http://www.sqlservercentral.com/columnists/ckirkwood/wait_types.asp

With what you describe, it sounds like your app is making many many calls to this select statement. Is it wrapped in...

I could throw it together easy enough if yall are interested.....always glad to help....but up to this point I have just done it manually.

LMAO......you are correct. In reading the article, I see your point. Just goes to show you that the readers didn't actually understand the difference, or perhaps rated it on different...

Post your actual code to do this in VB, and I'll write it in T-sql for ya....and yes, it can be done in T-sql.

Edited by - scorpion_66 on 03/29/2003 ...

There you go.....

Your customerid field is both an identity and a clustered index. This is a bad practice for table design. When you create a clustered index on a naturally...

When you said "One big COM+ transaction" does that not mean a single transaction? Which means that even though the statements are single statements, they are not committed until the...

If the update, insert, delete statements have an explicit where clause, such as where identityfield = 1, then you could expect row locking. If, on the other hand, you are...

Yes, you need a higher level of rights to the server. Generally, I have myself made admin on the server, so I could not tell you what level you absolutely...

Very nice......and so much cleaner than the one I use....If I could pass it a list of tables, and have it generate only the needed scripts (Related directly to the...

I use Query analyzer or notepad......

I would also tell your programmer to learn SQL or stay out of the server.....Just my opinion, but wiat till he actually develops something, people...