Viewing 15 posts - 211 through 225 (of 19,564 total)
April 1, 2017 at 7:38 pm
table paritioning is frequently used to meet this kind of requirement.
April 1, 2017 at 5:48 pm
April 1, 2017 at 5:43 pm
Yes move the log.
Are all of your data files the same size? Are they large enough to support the reporting requirements?
If you still have contention with...
April 1, 2017 at 5:36 pm
Those session transactions from December 2015 make me go :pinch:
Where was the single_user initiated from (ssms or some other app)? This wreaks of an orphand transaction from...
April 1, 2017 at 5:32 pm
If you do native backups and then just use actifio to backup the flat backups, then no impact on the native chain.
If you have a full + diff...
April 1, 2017 at 5:14 pm
April 1, 2017 at 4:46 pm
You can use this to help find your range values. You will only be able to merge one range at a time.
SELECT pf.name...
April 1, 2017 at 1:46 pm
alter partition function blah merge range blah (this is the range that was associated to the file you dropped).
April 1, 2017 at 11:01 am
April 1, 2017 at 10:57 am
Grant Fritchey - Saturday, April 1, 2017 2:47 AMIt's about the restore. The recovery. Can we do it? Consistently? Quickly? Accurately?
I want...
April 1, 2017 at 10:50 am
March 31, 2017 at 3:28 pm
Awesome sauce. Good luck.
March 31, 2017 at 1:02 pm
Does the user/login have any explicit denies? E.g. deny execute?
March 31, 2017 at 1:01 pm
Viewing 15 posts - 211 through 225 (of 19,564 total)