Viewing 15 posts - 3,676 through 3,690 (of 5,678 total)
:blink:
That is some complex join logic you've got going there.
Let's get back to the original design flaw, a table that's getting dumped and rebuilt every few minutes. ...
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 17, 2011 at 12:50 pm
pschwartzbauer (3/17/2011)
Is there a graceful way to accomplish this using SSIS data flow transformations?
No. You'll want to pretty much do this at the T-SQL level and feed it up.
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 17, 2011 at 12:43 pm
Correct. All it does is get you ready for a separation down the road.
The only time you get performance gains between the multiple files is when they are 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
March 17, 2011 at 12:15 pm
CirquedeSQLeil (3/17/2011)
Craig Farrell (3/17/2011)
CirquedeSQLeil (3/17/2011)
Brandie Tarvin (3/17/2011)
Craig Farrell (3/17/2011)
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 17, 2011 at 11:59 am
CirquedeSQLeil (3/17/2011)
Brandie Tarvin (3/17/2011)
Craig Farrell (3/17/2011)
Annnnd, now I have an image of sheep storming the castle. I wonder if they fit their armor before or after sheerings...
CRAIG!
Stop giving me...
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 17, 2011 at 11:45 am
Brandie Tarvin (3/17/2011)
Craig Farrell (3/17/2011)
Annnnd, now I have an image of sheep storming the castle. I wonder if they fit their armor before or after sheerings...
CRAIG!
Stop giving me story...
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 17, 2011 at 11:39 am
Phil Parkin (3/17/2011)
public void Main()
{
...
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 17, 2011 at 11:36 am
Phil Parkin (3/17/2011)
Yes, SSIS still uses this archaic form of not equals
Not that archaic ... so does C#.NET 🙂
Ewwww... VB ftw!
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 17, 2011 at 11:29 am
In the books section on the left, you'll find a book by Grant Fritchey called SQL Server Execution Plans. An excellent walkthrough on most of the things you'll encounter...
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 17, 2011 at 11:24 am
You guys take all the fun out of a quick one-liner. 😛
And Tomm, no they're not qermso... somethingorothers... they're just dumb and excitable, so they get ahead of themselves. 🙂
Annnnd,...
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 17, 2011 at 11:20 am
CozyRoc (3/16/2011)
I did the following:
- defined TaskName in ReadOnlyVariables input.
- called the following code from script: MsgBox(Dts.Variables("TaskName").Value)
And it worked, showing script task's name. I think it is incorrect to use...
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 17, 2011 at 1:56 am
Nevermind, I see the problem. You don't have evaluations in your strings, as Phil mentioned earlier. You need to test findstring to see if it found the character...
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 16, 2011 at 8:13 pm
Then group on the unionall of userid alone, then use that as a subquery back to the different tables to return the records.
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 16, 2011 at 8:01 pm
Jeff Moden (3/16/2011)
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 16, 2011 at 7:51 pm
Grant Fritchey (3/16/2011)
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 16, 2011 at 6:15 pm
Viewing 15 posts - 3,676 through 3,690 (of 5,678 total)