1st, dev boxes were upgraded to SQL 2005 first.  We have no PeopleSoft Database Servers currently running SQL Server 2000.

2nd, same boxes as before.  Uninstalled SQL Server 2000, installed SQL...

We update statistics nightly.  Didn't help.  Going to look more closely at the indexes.  Also asked sys admin to add lock pages in memory priv to the service account login. ...

Since you are using the field in a where clause, it makes sense to index the field.

Joseph, A full backup does not trunctate the transaction log.  A full backup only backs up enough of the transaction log to provide a consistent database during a restore.  In...

We did so many things over the weekend, I'm not sure if we did that or not.  I'll give it a try and see what happens.

Just in case it doesn't...

Start with this and let me know how it works:

--declare @trainreqs table (

create table dbo.trainreqs (

    client      char(50),

    typecode    char(10),

    grp         int,

    hrs         int

);

insert into dbo.trainreqs values ('CLI1', 'type1', 1,...

The quick way: script out your foreign keys, drop them, truncate the tables, reload the data, replace the foreign keys.

More detail would help.  Can you post the tables DDL along with some sample data and results?

Thanks

I don't see how you can eliminate the index scan (assuming you are indexing on the Comment field) unless you create a computed column based on the first three characters...

If you are doing a complete refresh of the data you need to complete the drop and add in the following order:

Starting with the lowest child table, start deleting records...

Have you checked the error logs to see if the there is a problem while SQL Server Agent is starting?  The only time I have seen Agent XP's disabled is...

You can turn this option off when using the SQL Server Scripts Wizard.  You start it by selecting Generate Scripts when right clicking on a database in Object Explorer.

You can also eliminate your cursor to build you column list using the following code:

declare @columns varchar(5000)

SET @columns = ''

SELECT @columns = @columns + [name] + ', ' FROM syscolumns

WHERE...

You might want to post your code for the UDF dbo.fnNoTime() as I doubt Best will figure out how to write it.

Take this and run with it.  You may need to tweak it to meet your needs but it is as close as i can get it for you.

set nocount on

DECLARE...