Viewing 15 posts - 2,461 through 2,475 (of 2,750 total)
Nope, IFI only affects the MDF / NDF, not the Transaction log.
A quote from Brad McGehee[/url]:
Instant file initialization only affects MDF and NDF files, not LDF files. In other words,...
April 3, 2013 at 1:11 pm
Once again, thank you...
In the interests of paranioa, I ran log backups of the 6 biggest log files to disk on the server. Thanks to Enterprise Edition, the backups...
April 3, 2013 at 12:19 pm
Everyone: Thank you for the ideas / suggestions
dan-572483 - Right now I'm not worrying about shrinking the files, that will come later. We're OK on disk space on...
April 3, 2013 at 11:06 am
Lynn Pettis (4/3/2013)
GilaMonster (4/3/2013)
jasona.work (4/3/2013)
1. After-hours, switch all DBs from Full Recovery...
April 3, 2013 at 10:32 am
Lynn Pettis (4/3/2013)
I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?
Depending on the time of day, either straight or filtered through ground-up and roasted Coffea...
April 3, 2013 at 7:51 am
You know, silly thing, but it'd be nice if you could specify credentials for a Windows Auth connection in SSMS...
I've got two logins, one for "normal" use which has no...
April 2, 2013 at 5:58 am
GilaMonster (4/1/2013)
jack-311987 (4/1/2013)
what if you enable trace flag 708, and use the (noaprilfool) hintThe universe implodes. Please don't try it.
Oh shoot, I hope I can go stop my run of...
April 1, 2013 at 12:12 pm
SQLRNNR (3/29/2013)
jasona.work (3/29/2013)
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
I'm debating between waiting until tomorrow, or going to see...
March 29, 2013 at 8:36 am
Steve Jones - SSC Editor (3/28/2013)
jasona.work (3/28/2013)
I'm debating between waiting until tomorrow, or going to see it tonight...
March 29, 2013 at 5:36 am
Steve Jones - SSC Editor (3/28/2013)
I know we don't keep people away, but treating them with respect, somewhat without regards to how snippy they may appear, is something...
March 29, 2013 at 5:34 am
Anyone thinking of going to see the popcorn movie that is "GIJoe: Retaliation"?
I'm debating between waiting until tomorrow, or going to see it tonight on my own, then tomorrow with...
March 28, 2013 at 10:23 am
BrainDonor (3/28/2013)
Lynn Pettis (3/27/2013)
What to make of this?May not be what I was thinking. Good.
"I'm a DBA, it turns out"
How do you suddenly discover that you're a DBA?
Maybe just...
March 28, 2013 at 5:17 am
Thanks, I figured that was going to be the best option, now to get the Dev to eat the pain of taking care of this...
With help...
🙂
Jason
March 27, 2013 at 8:38 am
Cool, thanks to both of you!
Jason
March 27, 2013 at 8:37 am
Never mind, I'm an id10t...
Forgot I don't need to wrap T-SQL in quotes in a T-SQL job step...
:Whistling:
March 19, 2013 at 7:43 am
Viewing 15 posts - 2,461 through 2,475 (of 2,750 total)