Viewing 15 posts - 1,561 through 1,575 (of 5,678 total)
The keys to this being properly 'thinned' is werknum table and the DR alias... which includes this lovely inline function to obfuscate any chance at using an index:
dbo.GetFirstDate(CJ1.Jaar, CASE WHEN...
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 11, 2012 at 3:59 pm
princa (5/11/2012)
Definition of view1:CREATE VIEW [dbo].[view1]
AS
Select *
From table1 t1
Left hash Join view v on t1.id = v.id
Don't force join types unless you're VERY sure of why you've chosen 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
May 11, 2012 at 2:49 pm
Happy Friday.
I fly to Vegas this weekend to visit some family for Mother's Day. Anyone else in town that might like to try to grab a beer or three...
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 11, 2012 at 2:44 pm
I've been thinking this issue over and to be honest, I think you're asking the right question in the wrong place.
We're SQL guys/Database Dudes. If you wanted to discuss...
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 11, 2012 at 2:03 pm
polkadot (5/11/2012)
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 11, 2012 at 1:03 pm
princa (5/7/2012)
But I still have some questions:
#1 - I am using a partitioned view to union two tables, one...
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 8, 2012 at 3:17 pm
Unfortunately not that I'm aware of. Because the Join will distribute the two halves of the join into both counts, you have to use correllated subqueries (basically the CTE...
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 4, 2012 at 1:34 pm
Dave beat me to it. You either pivot or crosstab, and he's provided an excellent example of the crosstab.
Pivots tend to be slower optimization-wise, and they're not necessarily easier,...
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 4, 2012 at 1:21 pm
If I had to guess you're not seeing all the errors being kicked back all the way to .NET and you're dealing with a double-hop issue.
What's your linked server set...
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 4, 2012 at 1:18 pm
Considering the number of views of this and that noone's responded, and that I'm utterly boggled by the occurence as I understand your description, this might be one to tag...
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 3, 2012 at 4:14 pm
opc.three (5/3/2012)
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 3, 2012 at 4:05 pm
Well, now, that's interesting. These are ISO dates with milliseconds, but the don't conform to actual standards. Instead of dissassembling the data, I'd recommend we adjust the data...
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 2, 2012 at 5:19 pm
sqlbi.vvamsi (5/2/2012)
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 2, 2012 at 5:02 pm
You've got variable meta-data. You can't do this directly in SSIS, it wants hardened metadata that doesn't change between iterations. There's some third party connections that can help...
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 2, 2012 at 4:21 pm
Soul, let me see if I understand what you're looking for. You're basically looking for something that looks like:
82 | Madrid | USA, Spain, Brazil
Or something that looks like:
82...
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 2, 2012 at 2:44 pm
Viewing 15 posts - 1,561 through 1,575 (of 5,678 total)