if the SQL2005 SP2 release is to be considered an omen for SQL2008 ....

I'm right there with you :doze::blink:

- Can you post the DDL for the PF, PS, the table and all its indexes ?

and the results for :

/*

show partitioned objects

*/

select distinct

p.[object_id],

...

and whyle you're at it ....

Split user object and system objects.

Create another filegroup, set it to be the default.

Move all your tables/clustered indexes to it.

There will be no immediate profit,...

- use auto update stats in the database options. This way you can lower the frequency of your updatestatistics job

Is this a SQL2005 enterprise edition ?

also schedude online index...

yep.

That's how I would do it.

btw.you can install the instance using dynamic ports, up to the sp/cu level you want it to be and then fix the portnumber.

Maybe it isn't...

If you cannot convert to set-based inserts (preferable bulk inserts) ...

skip the "if exists" but use the new SQL2005 try catch methode and put a unique constraint at the field...

just my 2 ct

- with mass deletes:

- limit the number or deletes per transaction to avoid (dead) locking.

- perform full table(s) maintenance after the operation to...

-if the cmdshell hadn't been actived, the exec would never work.

- put a print statement right befor the exec statement

print 'cmd: ' + @cmd

this way you'd...

well ... let's hope you are on SP2 with at least CU4.

- install MS performance dashboard (download free at MS):cool:

download it an install at as well client as server. It...

By the way (almost forgot)... they haven't fixed the code windows on this forum, yet. If you just copy and paste, they come out all on one line.

If you...

I should also note that after I created the partitioned table, I created a clustered Primary Key Index that was NOT partitioned (since the PK is different than the partitioning...

saveguard the query. :rolleyes:

There's some nice data in the box.

probably access via cmdshell is prohibited.

I've seen installations that raise a system error and log it into an audit log.

Contact the sysadmin(s).

since these logbackups start...

as stated in your OP, DTA does not support SQLExpress !

So you cannot use DTA with an SQL2005 express edition instance.