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

Matt Miller (11/6/2007)

I'm not sure...

Mark

It's to save you having to use a cursor or loop. Row-by-row processing is nearly always less efficient than set-based processing in T-SQL, and the numbers table allows you...