Viewing 15 posts - 3,121 through 3,135 (of 5,685 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.
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...
May 26, 2011 at 12:54 pm
Ninja's_RGR'us (5/26/2011)
Craig Farrell (5/26/2011)
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...
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...
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
...
May 25, 2011 at 5:38 pm
mister.magoo (5/25/2011)
Craig Farrell (5/25/2011)
May 25, 2011 at 4:57 pm
coronaride (5/25/2011)
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...
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...
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...
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.
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...
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...
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...
May 24, 2011 at 11:52 am
Viewing 15 posts - 3,121 through 3,135 (of 5,685 total)