Viewing 15 posts - 16,951 through 16,965 (of 59,067 total)
Rowan-283474 (8/23/2016)
Jeff Moden (8/22/2016)
Rowan-283474 (8/22/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2016 at 9:37 am
Ah... got it. Thanks for the time for the response.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:45 pm
GilaMonster (8/22/2016)
Jeff Moden (8/22/2016)
and only back to the last "dirty" VLF for log files.
Any shrink to the log file only removes space to the last active VLF. VLFs cannot...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:31 pm
Rowan-283474 (8/22/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:09 pm
Please help us help you with readily consumable code. You're almost there. Please see the first link in my signature line below under "Helpful Links". Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:05 pm
I guess my question would be, why are you using PowerPivot for this calculation to begin with? Why not "just" use T-SQL?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 7:56 pm
p.s. It's also not likely that you need to check for the file every second if you're willing to wait until 11PM for it. Why not just write...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 7:51 pm
I know squat about VB anymore but it seems to me that the following line would be a problem ...
While Now.ToString("hh:mm:ss tt") < dtStopTime.ToString("hh':'mm':'ss tt")
... because the single quotes are...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 7:37 pm
Something like the following Google search may be a help...
https://www.google.com/?gws_rd=ssl#q=copy+local+data+to+azure
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 12:00 pm
SQL!$@w$0ME (8/22/2016)
Thanks Jeff. Do you think SSIS is a possible solution?
All you're trying to do is upload stuff to Azure, correct? Like I said, I'm no expert there but...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 11:12 am
Gosh... I'd [font="Arial Black"]NEVER [/font](and I don't say that word often) use the OUTPUT clause for auditing. That would make auditing code dependent instead of just happening for any...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 10:55 am
SQL!$@w$0ME (8/22/2016)
What is the difference between BCP program and BULK INSERT. Are they both the same in terms of performance? I am trying to find a solution for bulk...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 9:44 am
RonKyle (8/19/2016)
Also, use numeric data types when appropriate (FYI, telephones and zip codes are not numeric data).
Social Security numbers are also not numeric. Once had a discussion with...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:26 am
Sean Lange (8/22/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 8:20 am
JasonClark (8/21/2016)
you can use NOTRUNCATE option with DBCC shrinkfile command.
That will certainly avoid fragmentation problems but will provide mixed results and will likely not return all unused space because the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2016 at 7:48 am
Viewing 15 posts - 16,951 through 16,965 (of 59,067 total)