This is similar to how we handle it. You will get incredible performance increases by not using the cursor. However I do it a little differently, we use...

I often work with a very similar issues. We do not use cursors (EVER). I'm hoping that the 3rd article address these kinds of issues. I will...

Ditto on the fact people think this kind of article is even needed/scarey (at least so far). I can't imagine ever writing the cursors for the examples the author...

I know that with smaller companies selling maintenance is critical to helping fund their bug fixes and new feature additions.

We resell ERP (accounting) software and I am sure that without...

My worst IT job is amazingly bad compared to those already listed. I worked for a man who did not understand programming. So if something was buggy late...

One technique I use when tunning is to make the sp a query then slowly add the lines as I run it again and again. Seems to make it...

You could use xp_cmdshell:

exec master..xp_cmdShell 'echo my file > c:\text.txt'

However you might have to change your security configuration to get this to work.

This link has some more examples:

http://www.nigelrivett.net/SQLTsql/WriteTextFile.html

John

Pradeep,

What I do in situations like this is preprocess the data. Use the SSIS job to copy the data to a temp table, scan it for errors and mark...

Steve,

Not everyone knows DTS stands for Daylight Savings Time.  Please include what your shortcuts stand for, DTS in my neck of the woods could mean many things, especially at Boeing...

Maybe you can give it a hint to use the non cluster index and see if that keeps the improvement in a large result set.

John