Viewing 15 posts - 331 through 345 (of 5,678 total)
Just because I want to see DBTIMEWARP get used:
The number line is not a line, it's a circle, proven by the Divide by 0 asymptote. You just have to...
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 6, 2014 at 2:32 pm
Q1 is simple enough and is simple join techniques, I wouldn't expect to see any issues there.
Q2 requires people to know about SARGability. While a definite skill I'd like...
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 6, 2014 at 2:29 pm
The procedure is triggering the trigger. You need to figure out which table it's on. Insert/Update/Delete will cause it.
However, you don't want to randomly drop a trigger, you...
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 6, 2014 at 11:05 am
venkat5677 (6/4/2014)
" Error: 0xC0029151 at ReportsToUsers, Execute Process Task: In Executing "C:\NewFolder\AAA.cmd" "E20070815" at "", The process exit code was "1" while...
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 4, 2014 at 11:29 am
Koen Verbeeck (6/3/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 4, 2014 at 2:36 am
The data flow doesn't work like a query, or like typical programming logic.
Don't think 'steps', think 'places in a stream'.
The data flow streams data from the source, through all the...
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 3, 2014 at 6:13 pm
Koen Verbeeck (6/3/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 3, 2014 at 3:42 pm
Sorry, ;WITH is ingrained into my head at this point. You're stuck with it if you chase me in my code.
I agree with a decent amount of what's been...
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 3, 2014 at 3:03 pm
Glad you found it Tom, good luck. 🙂
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 3, 2014 at 11:31 am
nivedita talukdar (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 3, 2014 at 11:30 am
Koen Verbeeck (6/3/2014)
Evil Kraig F (6/2/2014)
So, I've been... busy. 🙂 Hi guys, what's new?I met Grant in real life. I still have nightmares.
I'd heard he's a bit scary. ...
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 3, 2014 at 3:25 am
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 6:47 pm
You'll need to get some hands on experience at this point with SSRS and the VS2008 studio (you need the right version of VS or BIDS for each version of...
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 6:44 pm
Without seeing the data? Nearly impossible to troubleshoot directly.
What's the rowcount in VES?
What's the rowcount in EHR?
What's the DISTINCT SSN Count in both?
When you join the tables (instead of...
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 6:40 pm
ramana3327 (6/2/2014)
Usually it is better to include the columns in the index that are in where clause, select list and join.
I am thinking 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
June 2, 2014 at 6:38 pm
Viewing 15 posts - 331 through 345 (of 5,678 total)