Viewing 15 posts - 346 through 360 (of 5,678 total)
I have to agree with SQL Guy 1 above.
Define "Move Data". One shot vs. continous vs. scheduled. Mirror/snapshots, Transactional Replication, Backup/restore, Log Shipping, Bulk Data Files, and scripting...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 3:27 pm
Luis Cazares (6/2/2014)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 3:23 pm
We have a function to convert the database GMT to display BST, which adds one hour to the displayed time at this time of year,
BST? Either way, where...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 3:17 pm
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
7 hours and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 3:11 pm
Steve,
Thank you, that's got me straightened out. Much appreciated.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 12:12 pm
Obliged, Steve, thanks.
Now I've got a somewhat different issue, but I can see the echoes (and grab the .exitcode!).
However, when I run this .bat via cmd.exe, it returns what I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 31, 2014 at 5:31 pm
Glad to hear you're good to go auto.
Thanks for the cover J Livingston. Can't believe I forgot to put in the extra security wrapper... d'oh! :hehe:
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 23, 2014 at 5:51 pm
As promised, Auto, I'm back. Bit later than I'd hoped, but as usual I'm on the run again. Glad to see you were able to research my recommendation....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 22, 2014 at 6:51 pm
Auto,
While Eirikur's solution will work, there's a massive triangle join in the middle around that outer apply, unless I misread it (possible, I'm doped on Nyquil at the moment). ...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 19, 2014 at 11:23 pm
Pharmkittie: Good luck! Situations like that are another side of why I'd written the article, for anyone who just didn't understand what our jobs really looked like. I'm...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 7, 2014 at 11:12 am
Thanks for the kind words. I'm glad folks are still getting use from this article.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 4, 2014 at 5:56 pm
Change the internals of the data targets to only have a single column instead of just the copy/paste of the body. When I'm forced to do that I usually...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 4, 2014 at 2:50 pm
the connection to the third tier is AND, not OR, and thus both T1B and T1C are needing to run.
Change that to an OR and that should clean up that...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 4, 2014 at 2:18 pm
Thanks for the question Andy. Particularly like the setup.
I, personally, just dragged my lunch back into the office so Junior could stop freaking out and read me the blinking...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 21, 2014 at 6:24 pm
TomThomson (3/11/2014)
Koen Verbeeck (3/5/2014)
Setting the commit size to a lower value will commit batches before the entire load is done....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 11, 2014 at 11:28 am
Viewing 15 posts - 346 through 360 (of 5,678 total)