Very true. This tool logs you in with a local admin account with a password that changes every time. Plus it records who you are and everything you do while...

Thanks for the thoughts. My problem is my organization has gotten real zealous about security and now we can only RDP into servers through a certain tool and that tool...

Jeff,

I will definitely be moving this database to new storage and partitioning as part of the move. I would like to use your process, stored procs, etc. Here...

Excellent. I will be reviewing your presentation and instructions. Thanks much. I might be coming back with questions...

Sounds great. Thanks again for your time.

Jeff,

We can assume I will have more space on separate LUNs. FYI a few months ago I estimated the need for 2.5TB of space to keep us in good...

Thanks again for the advice and thanks Jeff for any time you spend on this.

My next concern with this big DB is the 2TB disk limit. I will likely...

Gail, "do I care" is a great question. Knowing this CI is highly fragmented offends my DBA sensibilities 🙂 but I am not getting complaints of slow queries against...

Jeff, this is Enterprise edition. I am attaching the DDL. There are two tables involved. Transactions is the parent and makes up 70% of the DB. ...

The CI on the big 5-month archive table is highly fragmented. Background info: this was implemented with a terrible clustering key - a random GUID. About two months...

Thanks to everyone for the notes and clarifications, especially the confirmation that a CI rebuild needs as much free space as the current size of the CI plus more space...

Thanks for the clarifications.

Imarkum,

Thanks for the reply but if understand the concept, the copy-on-write means a page of data only goes into the snapshot sparse file when that page gets updated in the...

Thanks for those suggestions. Believe it or not those two changes sped up the process considerably. It is back to being faster than the inserts and it caught...

The process is making pretty good use of indexes. It is only seeks and it's a seek on the nonclus index on ID for the TD table. I...