Viewing 15 posts - 1 through 15 (of 119 total)
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...
November 6, 2015 at 7:30 am
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...
November 6, 2015 at 7:21 am
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...
May 18, 2015 at 1:06 pm
Excellent. I will be reviewing your presentation and instructions. Thanks much. I might be coming back with questions...
May 13, 2015 at 7:38 am
Sounds great. Thanks again for your time.
May 12, 2015 at 11:11 am
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...
May 12, 2015 at 10:54 am
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...
May 11, 2015 at 10:30 am
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...
May 11, 2015 at 9:44 am
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. ...
May 11, 2015 at 9:27 am
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...
May 11, 2015 at 8:53 am
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...
May 11, 2015 at 8:05 am
Thanks for the clarifications.
March 3, 2015 at 10:06 am
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...
March 2, 2015 at 1:51 pm
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...
January 31, 2015 at 4:18 am
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...
January 30, 2015 at 1:29 pm