Have looked into it but the reviews I read 2 years ago were that it was buggy.

However the reported savings on CPU is so great I am surprised no one...

Your probably best using functions that can return tables.

select *

from table

where id in (select * from dbo.myfunction(@parameter))

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Run QA and type checkpoint and execute it.

Does this start some activity on your server?

Are you running a huge update or insert, if so and it has modified this amount...

Also found this

Q. When I try to start SQL Server 7.0 on Windows NT or from a Windows 9x Command prompt, I receive the following error:

Your SQL Server...

Look in BOL and then read the BUG article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303774

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Do you want to update data already there or just insert data where the PK values do not exist?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

There are lots of discussions at the moment on dynamic SQL.

Comments remove most of the SET @sql statements, bad for performance and readability just use CRs i.e

SET @sql =...

if you can still access them on sql7 you can use sysdepends to determine which ones, the id column is the id of the view, function or SP, the...

The stored procedure won't be re compiled on the basis of the dynamic sql.

And the dyanmic SQL might not be re compiled either if you are using sp_executesql and...

Pipe a file into it that contains the CR

myCon.bat < con.txt

where con.txt

username

password

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

From BOL

A checkpoint will occur when

The active portion of the log exceeds the size that the server could recover in the amount of time specified in the recovery interval server...

YOu can use sysdepends as well.

This finds all objects dependant on the orderid column of the orders table.

If you use dynamic SQL this won't pick it up so you will...

Here you go it is for 7 but won't have changed much for 2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_5pde.asp

Nice bed time reading

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

My understanding is that there is no scope on execution plans.

When a query is executed the plan is parameterised and match is looked for in the cache if one is...

Agree with most comments, my view is I have not enough time to do the real thing to cram for a test that will test things like producing web documents...