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

Ties

No, but you can create a user-defined function instead. Look in Books Online for CREATE FUNCTION.

John

You can script it using sp_configure (I think), or you can use the GUI. It's all in the documentation if you search for it. Set up a test...

Look at the SQL Server Properties (Security Tab) topic in (the most recent version of) SQL Server 2000 Books Online.

John

Well, if you have a standard installation it's Start -> All Programs -> Microsoft SQL Server 2005 -> Documentation and Tutorials -> SQL Server Books Online. It's all on...