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...

Hold your horses !

It can be done, but will your applications still work ?

Use the SQLUA...

The point is the dev-team need to be able to create/alter UDF and SPROCS (CLR is disabled for the moment) and are allowed to manipulate all the data of the...

Thanks for the csv