Viewing 15 posts - 5,176 through 5,190 (of 5,504 total)
Referring to the original purpose of The Thread:
Any consultant around ready for some charity work?
June 29, 2009 at 3:13 am
Hi Rohit,
Ramji (6/29/2009)
Kindly let me know if you guys need any more input on this.Rohit
It looks like you've misunderstood the concept of this site... We're not "free-of-charge-online-code-generators"!
The purpose of this...
June 29, 2009 at 2:34 am
What makes me wondering though is what Chris (the OP who started this thread in the first place) ended up with to tune his query... The subject he was talking...
June 28, 2009 at 5:13 am
Paul White (6/28/2009)
lmu92 (6/28/2009)
Paul White (6/27/2009)
Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...Paul
But how about the method I posted...
June 28, 2009 at 4:44 am
Paul White (6/28/2009)
... Well yes - but then we aren't comparing apples with apples anymore. Your method is specifically optimized for the data distribution you set up - and...
June 28, 2009 at 4:32 am
Paul White (6/27/2009)
Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...Paul
But how about the method I posted above (let's call...
June 28, 2009 at 2:25 am
I just ran across one of J. Sebastians article on how to do a string split using XML:http://www.sqlservercentral.com/articles/XML/61618/. Looks comparable...
June 27, 2009 at 4:30 pm
smsam1 (6/27/2009)
i know that this table is not is 3NF, since 'has_passed' depends on 'marks'. is it the same as saying in the second sentence
I'm not sure where you get...
June 27, 2009 at 3:32 pm
@Flo:
I always enjoy to watch two Germans arguing about an english statement made by one of them... - especially if I'm directly involved... 😀 I'm not sure whether I...
June 27, 2009 at 3:01 pm
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
...Just saw your post here
Maybe you missed this post by Lutz. There is a case where PIVOT seems to be much faster than cross-tab here.
Not if...
June 27, 2009 at 11:43 am
Hi Paul,
thanx for the test scenario!
When I ran your scenario (1 mill rows, 333333 client id's) on my laptop I got approx. 1.1sec for all three versions (CASE, aggregate and...
June 27, 2009 at 10:04 am
Hi Chris,
first of all thank you for taking the time to get the data together and post it here!
Great job! :Wow:
When looking at the numbers in your table I started...
June 25, 2009 at 5:06 pm
Now it's starting to get a little less cloudy...
The question is: Why would you try to save an Excel file using xml just to be able to import it into...
June 25, 2009 at 4:34 pm
Please read and follow the advice I refer to in my signature. It's still not clear what you're looking for. Please provide usable sample data.
Btw: I did see your original...
June 25, 2009 at 3:12 pm
That's one of the OP's responsibilities: To tell us what he/she is looking for...
You're right though, it's not obvious yet.
June 25, 2009 at 2:33 pm
Viewing 15 posts - 5,176 through 5,190 (of 5,504 total)