Here's an article on deadlocks for you:

http://msdn2.microsoft.com/en-us/ms191242.aspx

You should also check out sql-server-performance,com

No direct information on converting from dblib to ADO, but to me that would be a no-brainer ({;ve...

Considering we're talking about a VLDB that processes terabytes of data daily, even a "slight" improvement is a Good Thing. 

I've not worked with this before so can't help you directly, but you might want to try here:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=97&SiteID=1

Thanks for the feedback.  Sometimes I just need a sanity check.

Amen.

I've done application development and I've done DB design / SQL development.  I've had projects where I've done it all and projects where I was responsible for exclusively one or the other.  There is a...

Now this:

http://dsc.discovery.com/news/briefs/20060605/computerculture_tec.html?source=rss

is a project I'd love to be involved in.

1) go bash those developers and teach them how to code properly.

2) talk to your / their manager about this and get them...

select

[year],

uniqueid as b

from geoff...test1

where uniqueid > 340000

order by uniqueid

From what you've posted, I'm guessing

SELECT DISTINCT

org, acct, class, prod, note, htmltext  

FROM table

ORDER BY acct DESC, prod

would work.

Awesome information, guys!

Many, many thanks.

Just so you know, given the query and what it was doing, I changed it to DISTINCT.  If nothing else, it will help the developer...

Yanno, I thought it might be something like that.  So, I took a look at the query execution plan for each and they are exactly the same.

Odd.

Relationships do enhance the design process.  By thinking them through, I wind up with a better DB design.

Established relationships (FK's especially) also help those that come after you.  Try attempting to...

This:

IF @ProductName  = null

Should read:

IF @ProductName is NULL

DECLARE

@mycheck int

IF @mon=1

set @mycheck = 216

else if @mon=2

set @mycheck = 244

.....

where

....

dateDiff(day,v.dateService,@myDate) < @mycheck