If your table is very large and the time it takes to delete a subset of the data is an issue then perhaps you could partition the table? Assuming...

one year ago...  so now that sql2005 is out would you not prefer to use Service Broker? 

I've had to deal with the issue of pulling and pushing small amounts...

not knowing much more about your scenario I would simply suggest if its an ftp location then use a DTS package.  its FTP object is very easy to work with...

if you mean you want the person running the report to select how they want the results sorted, you can also let them pass that option as a parameter to...

Nice, but I have to admit it seems a very complicated solution.  Circumstances are probably different but I used a bit of t-sql to do a very similar thing.  In...

I agree with Avi. We're also checking separate scripts into VSS and finding there are a few other benefits to storing each object separately.

Firstly we've found that...