Viewing 15 posts - 3,121 through 3,135 (of 5,678 total)
It's because of the uniqueness of this: ORDER BY new_id,base.id,base.colid
That uniqueness doesn't let it cache.
It's all about the uniqueness of the input into the Applied structure.
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 26, 2011 at 12:59 pm
Elliott Whitlow (5/26/2011)
Somehow I put Paul, Kalen, and such at well ABOVE Senior, level 4, 5, 10?CEWII
It depends, as always. The 'public' personas at that level are writing books...
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 26, 2011 at 12:54 pm
Ninja's_RGR'us (5/26/2011)
Craig Farrell (5/26/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 26, 2011 at 11:18 am
I personally would label you as a II, but an unexperienced one mostly because you've only dealt with very few servers simultaneously and only one company. You're competent enough...
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 26, 2011 at 10:52 am
kuppurajm (5/25/2011)
I am using identity column in table.but not set that column as primary key.
by makking that column as primary key any performance will be...
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 26, 2011 at 12:18 am
Alright, let's start from scratch and get rid of the curiousities.
SELECT
t.n, [RandomCoinTosses].[Result], x
FROM
...
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 25, 2011 at 5:38 pm
mister.magoo (5/25/2011)
Craig Farrell (5/25/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 25, 2011 at 4:57 pm
coronaride (5/25/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 25, 2011 at 4:55 pm
I've got a bad feeling this has to do with repeated name in syscolumn and the apply function. I'm not done chewing on this one yet, just haven't had...
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 25, 2011 at 4:52 pm
Apologies to those who were trying to help me with this. There's an error in the build script that's not actually showing up in my issue. Price history...
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 24, 2011 at 6:35 pm
You have to change the originating definition in the XML file connection, so the metadata is modified.
Basically you'll have to start at the beginning of the flow and track 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
May 24, 2011 at 4:57 pm
It's truncating, basically. The value coming in from the XML is bigger then a 4 byte int. Try an 8 byte BIGINT.
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 24, 2011 at 4:28 pm
jasonshaw (5/23/2011)
Thank you for that GilaMonster.I was planning to use the @@IDENTITY function to get the job number back, I don't think I had made it clear enough.
jason
As a recommendation...
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 24, 2011 at 3:23 pm
djackson 22568 (5/24/2011)
Maybe I am not hearing what people are trying to say here, and if so I apologize. What I am hearing clearly does not make sense.
It's 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 24, 2011 at 3:18 pm
sgambale (5/24/2011)
On dev/test we were able to get about 80 GB of tempdb on 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 24, 2011 at 11:52 am
Viewing 15 posts - 3,121 through 3,135 (of 5,678 total)