This is hard work, isn't it? You've been asked four times now to post the code of the trigger. You have to help yourself if you expect anyone...

Read about BCP, bulk insert and SSIS and choose the one that suits you best. You can also use linked servers and OPENROWSET.

John

Do you have any DDL triggers defined on the database or server?

John

Rajeev

You've got seven different SELECT statements in there. Have you tried running them individually to see which one is taking most of the time? Once you identify that,...

Is there a question here, and if so what is it?

John

I believe OS error 112 relates to disk space. I know you say you have 63GB free, but have you checked the free space on the drive where the...

Use DBCC INPUTBUFFER to see what query is running on the blocking process. Then go through the normal steps to troubleshoot that query - eliminating any row-by-row processing, ensuring...

I haven't tested this, but even if it's not entirely syntactically correct, it'll point you in the right direction.

SELECT m.IdSeq, m.MyName

FROM MyTable m JOIN (

SELECT MAX(IdSeq) AS IDS

WHERE KeyValue =...

Not...

Sorry but we're not going to do your homework for you unless you show you've made some attempt to solve the problem yourself.

John

SELECT * FROM MyTable

WHERE MyColumn LIKE '%''%'

John

Great article, Andy - thanks. Can I just ask a question about Tip#4?

If you want to really make sure no resultsets occur you can use spconfigure to set disallow...

I think by "a quick example" you mean you want us to do all the work for you. You've been posting here for a long time so I don't...

If you're writing the procedures yourself, rather than working with existing ones, then why not just use an output parameter to return the name(s) of the table(s) used? You...

You can't use dynamic SQL in a view, since you would need EXEC or sp_executesql to execute the SQL, and a view definition can only consist of a SELECT statement....