It appears to me that xml indexes cannot be put to a different filegroup from the underlying table, if the table is partitioned ( over filegroups ) then the index...

I looked at your post and thought - no idea offhand - then thought that possibly you might be taking the wrong approach with your use of partitions - normally...

I'll echo Gail's comments. You need to be aware of the _WA stats which can in extreme circumstances stop you building an index, in a tuning scenario I usually delete...

sqlio won't really do much other than show figures which may or may not relate to sql server io, you need to know what your projected io patterns are to...

sql 2005 has this ability ( but i've not checked it actually works.) there is no easy way to do this in sql 2000.

Mu usual approach is to profile by...

I need to understand a few things here - do you have awe enabled for sql server?

How are you viewing/measuring memory usage?

Having attended a few of Itzik's presentations I have to say he is a master at presenting ways around what you think you can't normally do , however, I didn't...

large data loads normally go quicker in batches, especially if you can change the database mode to simple or bulk logged. Make sure you're not getting filegrowths as part of...

I do quite a bit of this and there will not be a golden fix .

With more memory than database you will have eliminated disk issues except for tempdb...

the critical obvious one is that you still get the same end result - I know this sounds rather silly but knowing what you should get and making sure you...

In general triggers are absolutely the worst way to go as they willd egrade performance. If it's complaince issues then you should check out Compliance Manager from Idera, I use...

well, maybe, but two years doesn't sound new to me.

The inside sql server books would be my first port of call, there's three which probably cover your question;

Applied Techniques, T-SQL Programming and T-SQL Querying.

http://www.microsoft.com

why ?