Viewing 15 posts - 18,871 through 18,885 (of 59,072 total)
WhiteLotus (12/21/2015)
I am thinking to change it to 512 MB . What do you think ?...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 8:11 pm
Oh, and getting back to the title question of this post of "DBA Tasks - To automate or use my own eyes", the only correct answer is both. Automation...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 8:03 pm
matt.warren 33350 (12/21/2015)
I can't thank you enough for all your help.
I ran into some errors with the code you helped me with, but having seen your advice, it makes...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 7:47 pm
Jason A. Long (12/21/2015)
Jeff will no doubt follow up with something super cool...
Not so much as the hierarchical query goes. You pretty much topped that off quite nicely....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 7:21 pm
ScottPletcher (12/21/2015)
Yeah, everybody always "warns" about that, but who on earth would want to apply a 299GB log anyway??
Obviously and especially in this case, it wouldn't. The log file...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 6:52 pm
John Hanrahan (12/21/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 4:36 pm
There are three things that I absolute don't believe in automating... a cocktail before and a cigarette after. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 4:33 pm
And if you do cycle through the SIMPLE Recovery Model, don't forget to at least do a DIF backup after you return to FULL recovery to restart the log chain.
Also...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 4:31 pm
T2512 (12/21/2015)
During an interview I was asked apart from reducing speed, what else does a developer...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 10:47 am
Eric M Russell (12/21/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 9:47 am
simon_s (12/21/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 9:40 am
only4mithunc (12/21/2015)
I have a flat file source with a field of type date time ( it has got the data in Year-Month-Day-Hour-Minute-Second-Millisecond format )
In the destination table I have...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 9:20 am
T2512 (12/21/2015)
I am relatively new to SQL Server. I had a view that was taking about 10 min to run, i was able to reduce the time to 3 seconds...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 9:14 am
patricklambin (12/20/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 8:29 am
WhiteLotus (12/20/2015)
Yayy you are right !Now I get 99% free space . Thanks so much !!
Now you need to shrink it. It's going to take a long time and...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2015 at 8:26 am
Viewing 15 posts - 18,871 through 18,885 (of 59,072 total)