Viewing 15 posts - 3,211 through 3,225 (of 5,678 total)
theunique1011 (5/6/2011)
Sorry one one answered.
You need to have more patience. This is a forum board of volunteers, not a help desk, who work at their own pace and 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
May 6, 2011 at 1:16 pm
That's a GIGO problem. (Garbage In, Garbage Out).
You need to go back to the business and get their business rules on this and for what they want. This isn't...
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 6, 2011 at 1:13 pm
andy-973092 (5/6/2011)
Right now I am using Fingerprint Assignment in ssis to identify the new and missing. However, we are not happy with the performance of this.
Is this a third...
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 6, 2011 at 1:10 pm
SQL ORACLE (5/6/2011)
We do not have any information on these...
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 6, 2011 at 12:27 pm
Brandie Tarvin (5/6/2011)
Editor's Note:
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 6, 2011 at 11:01 am
calvo (5/6/2011)
i want royalties. lol.I'm sure we could think of a whole ton of great sayings like that.
DBAs: We monitor your packet-size.
DBAs: Scanning the bar, but seeking a date.
... I'll...
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 6, 2011 at 10:50 am
kcbeard (5/5/2011)
example data
ProductID --- ProductName
1...
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 5, 2011 at 6:53 pm
coronaride (5/5/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
May 5, 2011 at 6:23 pm
^ Listen to this man, he's one of your best bets for partitioning help 'round these parts! :w00t:
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 5, 2011 at 5:15 pm
duncfair (5/5/2011)
Still, shifting partitions seems to be the only way to go.
I'm still re-wrapping my head around partitions atm, but this here looks like a good way to deal with...
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 5, 2011 at 4:57 pm
duncfair (5/5/2011)
Thanks for the help, but I would have to be updating hundreds of millions of rows each day (or even once a week) - ugly!
The way you were looking...
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 5, 2011 at 4:20 pm
No, not directly. You'd have to run Alter Partitions on a regular basis. Considering your desired partition scheme, I'd probably do it on weekends.
Check out these urls:
http://stackoverflow.com/questions/5140566/partition-table-based-on-variable-value-sql-server-2008
And 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
May 5, 2011 at 4:15 pm
shannonjk (5/5/2011)
No worries take your time. I have been looking for a solution as well, I will post something if I figure it out 😀
Shannon, to confirm, in the end,...
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 5, 2011 at 2:51 pm
Chad Crawford (5/5/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
May 5, 2011 at 2:37 pm
dg227 (5/5/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
May 5, 2011 at 2:32 pm
Viewing 15 posts - 3,211 through 3,225 (of 5,678 total)