Check this out:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=12287

What error are you getting with OSQL?  Can you post the error syntax?  Have you tried the -E switch with OSQL? 

For example, >OSQL -S <servername> -E -Q "select *...

I agree, this sounds like a cluster problem not SQL Server.  You said: "Spent alot of money to do this and after 3 attampts to cluster"; does this mean that...

Claude,

There are a couple of things going on here.  First, you want to know if you can prevent your SELECT from blocking your UPDATE.  The answer is yes, but...

Well, first of all, you'll need (or want) a unique index on Customer No and Site ID in your thrid table.  You could then either have the INSERT trigger determine the...

You're right, a table can have millions of rows.  I've never had problems running QA using Microsoft's Remote Desktop Connection (formerly terminal services).  If this starts happening again, I would...

Well, there are a few things to consider here.  As SQL Oracle stated, using filegroups can help you improve performance.  This is done by spreading...

Remi, I did not read you post prior to submitting mine.  You are correct.  SysDepends may not be 100% accurate.

That should work too.  I also should have used DISTINCT.  Your solution may return stored procedure names that do not actually reference the table.  Let's say that you have the...

SELECT SO.Name

FROM SysDepends SD

    INNER JOIN SysObjects SO

    ON SD.ID = SO.ID

    INNER JOIN SysObjects SO2

    ON SD.DepID = SO2.ID

WHERE SO2.Name = 'XYZ' AND SO.xtype = 'P'

Doug,

Here is the KB: http://support.microsoft.com/kb/899761

I see a couple of things here.  First, did you apply the AWE hot fix for SP4?  If not, there is a bug with AWE in SP4 that Microsoft has...

So instead of merging filegroups, you need to merge datafiles within a filegroup?  If so, make sure your target datafile is set to autogrow, then run a DBCC SHRINKFILE <FileName...

Gabola71, what does the COALESCE end up doing to your query plan?

Ken and Sergiy,

Ken's theory is interesting.  I too have seen 3rd party optimizing tools (Quest Cenral) where COALESCE was...

Personaly, I would put this into a stored procedure.   What are you going to do with the comma delimited list once it is returned?  The reason I ask is that...