Again, I think that you should revise that code.

For example, consider deleting the records "chunk by chunk" - i.e. not all records in a single DELETE operation.

Also I'm not...

Try this example taken rom BOL ---> IS_SRVROLEMEMBER (Transact-SQL)

IF IS_SRVROLEMEMBER ('sysadmin') = 1

print 'Current user''s login is a member of the sysadmin role'

ELSE IF IS_SRVROLEMEMBER ('sysadmin')...

Does your backup strategy include log backups?

As you've been previously told, revise the code. Also if you do bulk data import / inserts, change the recovery model to "bulk logged"...

This can also be done in .NET using regular expressions...

See if this helps you:

http://blogs.techrepublic.com.com/datacenter/?p=420

Try to change the stored procedure so that it gathers only the data that changed since the last time it ran. How you'll achieve this depends on the db schema...

Use the nodes() method of the XML data type. BOL ---> nodes() Method (xml Data Type) is a good starting point.

You can also consider to use an XML schema...

I'm not sure what do you want to achieve with the piece of code you've submitted, but first of all please let me remark that:

- the code is prone...

You should run DBCC CHECKDB on a regular basis - maybe not daily (and here I am a little "off topic") - but I think that you should not forget...

The document recommended contains the performance related discussion.

Paul, it's a shame I'm o lazy...:blush:. Thanks for the detailed example.

Indeed it is a terrible design...and the boss seems to me a "micromanager" - sorry, Adam...

I'm not sure whether I've fully understood you - it seems to me that you can use the UNPIVOT operator here.

Select the columns you need in another table (T1), use...

You can also create a SSIS package (for example using the wizard recommended) or bcp out to a .csv file.

If you're working with SQL 2005 (you should if you're on this section of the forum :)) or later use (var)binary / varbinary(max). See BOL for details.

Before deciding whether to...

Are the database and the application properly documented? Is there any performance baseline available for that server?