Viewing 15 posts - 76 through 90 (of 5,678 total)
Simply put, you can't (at least up to 2k8), which is why you're having trouble with it. The Data Flow task is actually a single component, it doesn't have...
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
October 7, 2014 at 4:04 pm
ramana3327 (10/7/2014)
I have a table which has manufacturing date column but they use the varchar instead of datetime datatype.
You'll need to convert them then compare as the easiest method. ...
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
October 7, 2014 at 2:42 pm
Koen Verbeeck (10/7/2014)
Maybe he's schizophrenic.
I'm Crazy!
I am NOT!
Yes, I AM!
Dammit, you two, shut up! This isn't getting the four of us anywhere.
(beat)
Four?
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
October 7, 2014 at 1:15 pm
djj (10/7/2014)
Not because I suggested it, but a need for 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
October 7, 2014 at 12:18 pm
I believe we need to disabuse you of a notion you seem to have.
SSRS and SSIS are not meant to be real time applications, not in the way it's traditionally...
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
October 7, 2014 at 12:03 pm
I've inherited tragedies similar to what you describe.
My first step is to open Visio. My second step is cancel my meetings for a week.
I create a hybrid DFD/Processing Diagram....
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
October 7, 2014 at 11:55 am
Congratulations Jason and Jack. Well deserved.
Sorry I've been AWOL lately. Anything else I've missed in the last week and a half or so? Work's been taking it...
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
October 1, 2014 at 1:48 pm
Great list! Sent the link around the office.
There's a commandment missing from this, though it's somewhat related to the Aye Aye Capt'n Bligh Commandment:
We are not the business; we...
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
September 18, 2014 at 6:43 pm
shahi.alokchandra (9/17/2014)
Actually i am having more then 100000 rows in table and if i use functions then my index might not be called.,that why want to avoid cases and functions.
Just...
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
September 18, 2014 at 2:23 am
I can confirm that (MAX) (any form) variables are passed byVal up to version 2K8 R2. byRef is reserved only for the table variable parameter, and that is a...
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
September 17, 2014 at 6:53 pm
I don't mean to be a complete schmuck, but that's the kind of thing I get hired for, not volunteer on a board to help folks do their work 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
September 16, 2014 at 12:25 pm
I'm fueling up my motorcycle, packing a small backpack, and will be visiting each and everyone one of you on the days that you say your meat's ready.
I don't have...
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
September 16, 2014 at 12:15 pm
courtney.smith (9/16/2014)
At the end of the day stored procs or views start to become a maintenance nightmare on any sufficiently large system.
I would posit that it's easier to maintain 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
September 16, 2014 at 12:07 pm
Picket sign:
===========
- Blow Up -
- the -
- ORM's! -
===========
=
=
=
=
Okay, I'm not against the concept of the ORM....
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
September 15, 2014 at 7:24 pm
You're fine Jack. He doesn't understand that without knowing the data and structure you can't simply answer thiscolumn-thatcolumn as the expression. He's also frustrated and he's chewing on...
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
September 9, 2014 at 5:02 pm
Viewing 15 posts - 76 through 90 (of 5,678 total)