Many ways, but it depends greatly on what the root problem is.

Have a look in the performance forum, iirc there are a few posts on getting started with monitoring...

However, if you're still using SQL 2000, then the max datatypes are not available (New feature in 2005) and you're stuck with TEXT for large text strings.

The error has more to do with the wierd way text fields behave than anything wrong with your parameters. You might have some success using READTEXT, but I don't really...

What you're trying to do can't be done in SQL 2000 (function in FROM with parameter been a field from the query). It's a new feature in SQL 2005 (CROSS...

In theory

CREATE PROCEDURE TestOutput (

 @InputParameter INT

 @OutputParameter INT OUTPUT

)

AS

.....

DECLARE @Result INT

EXEC TestOutput @InputParameter = 1, @OutputParameter = @Result OUTPUT

Note the OUTPUT keyword, both when creating the stored proc and wne...

and statistics cannot be mintained on them, so the optimiser has little to no idea how many rows are in the table variable when it generates a query plan.

If you are going to be doing this kind of query, create a linked server and map the windows authenticated logins on one to a sql authenticated login on the...

Cursors, especially nested cursors are not going to work very well, ever. I suggest a set-based solution.

This isn't a complete solution, but should give you a good idea where to...

IF EXISTS(SELECT 1 FROM mytable)

 RAISERROR (...)

No need for variables or anything.

I usually use this when I'm optimising queries.

set

statistics io on

set statistics time on

From books online

I tend to use this one. Not sure if it's the best, but it is way better than the usual cast as varchar version. Haven't seen any strange issues

SELECT CAST(FLOOR(CAST(GETDATE()...

What does this return?

DECLARE @val VARCHAR(50)

SELECT name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsConstraint') = 1 AND name like 'PK__TestTable%'

select @val = name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsConstraint') = 1 AND name...

If you print the string instead of executing it, what does it contain?

You'll need to use dynamic SQL in this case, as an alter table can't take a variable.

DECLARE @val VARCHAR(50)

select @val = name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsConstraint') = 1 AND...