I'd rather have slow, steady and accurate then some of the other things I've seen posted on the web elsewhere. Take your time Steve and keep up the good work...

No Arrays <period>. An array is a repeating group, not unlike like rows in a table. So it's kind of 'not allowed' in a relational database.

Here's a bit more detail taking off on Colin's advice:

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all...

I'd also look at the size of the table. Any table less than 1 Extent (8 - 8k pages) will not be defragmented anyway no matter what you do.

Whether or not there is a space after the command flags has nothing to do with it. I'd check into your Windows Security and Authentication on the Server since you...

With no data in the nvarchar column whatsoever - 2 bytes (1 indicating nullability, one indicating length) and 1 bit in the null bit map.

Check out BOL for all...

If you are meaniing a backup file other than the normal full backup (I call them 'special' or 'one-time' backups'), there are a few reasons. DB upgrades, software upgrades and...

Make notes of:

• Server OS, SP and hotfixes installed
• SQL Version, SP and hot fixes installed
• Cluster configuration (google the 'cluster' command)

Get backups of:

• Windows 'system state' - the registry
• Full backup of both nodes -...

Please do not post the same topic multiple times ...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=296039

Transaction logging is part and parcel of a relational database. This is what helps you maintain data integrity. Local temporary tables (#) and global temporary tables (##) are created in...

If you network is 'switched' you will only see the SQL Servers 'broadcasting' on your current network segment. If there are firewalls present this may also affect the listing of...

Its not about:

• the marketing 'hype' - which has died down.
• the 'new' features - there are many, but the value provided for us is truly nothing since we will not make...

If hardware is similar then you may need to do a little maintenance. It may alleviate your performance disparity.

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with...

Very goog points Chris ! I am curious as well.

I agree, schedule the time to build a new cluster if at all possible. If you do not take this approach then you may be in for the same amount...