..Now I have to go find out why all our upgraded master databases are set to a compatbility level of 80...

If you've upgraded, the compatibility level has not been changed....

maybe this can help you out ....

create table #PhoneCalls (CallId int not null identity(1,1) primary key, CallTime datetime not null, CallEnd Datetime not null default ('9999-12-31 00:00:00.000'), CallDuration int not...

as you will have noticed, SSIS is not cluster aware. What I mean is SSIS is not member of a cluster group, unless you install it yourself.

This means, you'll have...

In short :

The delete query :

DELETE t1

FROM

(

SELECT

ROW_NUMBER() OVER

this works for me ...

I've created a table (csv_test) with 256 columns , saved the xls as csv and used this statement :

BULK

I've tested the # ways on a testbox singleproc 1,8mhz / 1GbRam with 10,000,000 rows per table and cleared buffers to begin with ...

I thought I just might add some refs regarding choices for SSB - MSMQ - Biztalk, ...

http://keithelder.net/blog/archive/2006/02/22/using-the-right-messaging-technology-msmq-biztalk-or-services-broker.aspx

http://blogs.msdn.com/rogerwolterblog/archive/2006/02/28/540803.aspx

and even a middleway : http://weblogs.asp.net/gsusx/archive/2005/09/26/425989.aspx

does the sqlserver service account have access to c:\ ?

- did you execute your dbmaintenance (dbcc dbreindex(yourtable) ) ?

1) Why are you using dynamic sql or this ?

2) there is something wrong itn the last innerjoin what are you innerjoining with ? (there is no match with the...

select ...

from table1 T1

inner join table2 T2

on T2.servername_loginname like  '%' + T1.Loginname 

or

select ...

from table1 T1

inner join table2 T2

on substring(T2.servername_loginname, charindex('_',T2.servername_loginname) + 1, len(T2.servername_loginname) = T1.Loginname 

Isn't that one of the goals of this kind of forums  ?

No only to be creative, but being creative in an reasonable way

choosing will not be difficult at all ... compare execution plans !

If they are equal : pick one

If they are not equal, the choice is obvious

DELETE t1

   FROM yourtable t1

inner join (select AccountID , max(MyDateTime&nbsp as MaxDateTime

               FROM yourtable 

               group by AccountID ) t2

  on...

This thread contains a very good syntheses regarding Clustering.

Also keep in mind that for best practise , you should check that your clustering...