I have been looking at the cache (syscahceobjects) and it is sometimes stored case-sensitive. I think this is with adhoc SQL, but not stored procedures.

Remember also that the first call...

Index views have been intoduced (I believe) to aid the performance of aggregate operations. If your index does not use aggregates then the view is generally broken down with the...

This is something I don't believe may people take notice off. If you look at the scripts generated by EM they contain alot of SET statements.

You need to ensure...

So what you need is

DECLARE @OID int

exec sp_executesql @sql, '@OID int OUTPUT',@OID OUTPUT

SET @Result=@OID

RETURN @Result

Be aware that using dyanmic sql means you need to give users writes to the underlying...

textcopy works very well.

If you are going to store documents, consider storing them on a seperate filegroup, which aids backup and recovery.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

YOu would be better off renaming the old table, dropping the constraints, then recreate the table with the new column, populate it with an insert into and then add the...

What is the update statement you are using?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

Having only 3 disks in an array is not going to give you much in terms of performance, you would probably be better off with 1 array of 5 disks.

Of...

I always found it to be the case when each parallel process was processing large blocks of data. And yes I haven't some across it yet in 2K.

Simon Sabin

Co-author of...

I can well believe that the index tuning wizard cannot cope with udfs. It all comes down to determining what will come out of the function.

If you use an "Inline...

What doe syour sql function do? Are you using ado, dmo ?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

The point is that floating points will store decimals inaccurately. i.e if you put 0.03 in the database it will probably store it as 0.029999999. So you will never be...

What is the definition of your tables and view?

Checkout everything in here,

http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_06_17zr.asp

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

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

The other option is parallism. If you have a poorly performing query that has a query cost larger than your parallism threshold noremally 5 then the query will try and...

Need to be careful, using left join. If there can be > 1 record in tblRCStudentGrades for a particular Pernum then your query might be better off using NOT EXISTS....