Viewing 15 posts - 31 through 45 (of 84 total)
Thanks all for the excellent advice and pointers. I am slowly altering all these databases to be of the SIMPLE recovery model and shrinking the LOG files to 50mb...
October 28, 2016 at 5:28 am
Jeff Moden (10/26/2016)
HanShi (10/26/2016)
Jeff Moden (10/26/2016)
1. Set the SIMPLE...
October 26, 2016 at 2:57 pm
October 26, 2016 at 1:05 pm
So if I understand things correctly, if I have these set to Simple mode, then the size of the trans log is really not all that important since we will...
October 26, 2016 at 12:58 pm
Jeff Moden (10/26/2016)
Siberian Khatru (10/26/2016)I'm kind of torn here as to whether or not to bother other than to switch to SIMPLE. I would guess at this point that leaving...
October 26, 2016 at 8:17 am
Yes, I do realize that switching these all to SIMPLE will render point in time recovery as impossible. I made it a point to mention that to the proponents...
October 26, 2016 at 7:27 am
jasona.work (10/26/2016)
Siberian Khatru (10/26/2016)
October 26, 2016 at 6:46 am
I just went ahead and rolled the server during off hours...thanks though.
May 25, 2016 at 11:00 am
Steve Jones - SSC Editor (3/10/2016)
If you use SSMS and the ADMIN: trick, you likely need to be on the...
March 10, 2016 at 5:47 pm
A appreciate all the replies and I've just gotten clear of this after one hellacious day. The DAC facility simply doesn't work in our clustered environment so I could...
March 10, 2016 at 2:54 pm
spaghettidba (3/8/2016)
If you want to do that with...
March 8, 2016 at 2:26 pm
Great content, other than the typos and nomenclature things others have already mentioned. Thanks!
February 17, 2016 at 8:37 am
Thanks one and all for the tips and advice...I plan to pass this thing in just under 30 days, or even sooner if I can. I need to get...
January 7, 2016 at 11:05 am
GilaMonster (1/7/2016)
For aggregates, read up and practice group by, the aggregate functions (sum, count, min, max, etc), practice...
January 7, 2016 at 8:48 am
GilaMonster (1/7/2016)
Siberian Khatru (1/7/2016)
- Was the test I took a fair representation of what I can expect on my free retest from a subject matter perspective?
Probably yes. You'll get...
January 7, 2016 at 8:36 am
Viewing 15 posts - 31 through 45 (of 84 total)