Viewing 15 posts - 1,066 through 1,080 (of 1,182 total)
Hello Igor,
It's not a bug. The problem is that you are relying on implicit conversion that have no contract whatsoever. The surprising results you got caused by the difference implicit...
May 31, 2007 at 10:51 am
Hello Jeff,
The results are almost identical, plus or minus 1 second. It does seem from this unscientific test that the varchar(8) version is a tiny bit faster than varchar(10) when running against...
May 31, 2007 at 10:27 am
Hello Igor,
2.b Even in your example you should be surprized, why charindex returns 2, and not
select CHARINDEX('.',
May 31, 2007 at 10:08 am
Hello Robert,
Yes, I see it in the index. But it is almost impossible to find by searching for it - and because I did not know what the operator was...
May 31, 2007 at 8:48 am
Hello Jeff,
Thanks for your reply and thanks again for the excellent example you provided. I will run the tests you propose and let you know the outcome.
webrunner
---
webrunner
May 31, 2007 at 8:36 am
Hello Igor,
Thanks for your reply. Here are my replies.
1. "I did it without % because I...
May 31, 2007 at 8:02 am
This is great. I mentioned you in one of my other posts, a reply to Sergiy, and I hope you read my comments.
By the way, I don't know if this...
May 30, 2007 at 2:18 pm
Hello Sergiy,
I agree with you in general, with the following elaboration. I think it depends on what the interview questions are asking. I wouldn't dismiss someone who got an answer...
May 30, 2007 at 2:04 pm
Here is mine. I did it without % because I couldn't find the mod function by name in Books Online and did not want to give in and go to...
May 30, 2007 at 11:46 am
I completely agree and did the same thing! I have to wonder whether there is something wrong with this approach that would preclude from being used as the behavior of...
May 30, 2007 at 10:28 am
Ha ha!
Sample dialogue using the 'B' answer:
BOSS: I see you are querying an offline cube in Analysis Services. Can I access your cube as well to perform some analysis?
DBA:...
May 25, 2007 at 10:04 am
That's a good point about Apple. They certainly have that reputation, and it has been furthered by a jealously loyal user base.
How much of that reputation is based on a...
May 21, 2007 at 9:47 am
Since the query returns the number and the names (if you run it in Query Analyzer the number shows up for you in the status bar anyway), I didn't see...
May 21, 2007 at 9:19 am
My completely anecdotally based guess is that it will be at least a generation (20-30 years) before anything like real 100% automation exists for an entire company's IT infrastructure -...
May 21, 2007 at 8:43 am
Viewing 15 posts - 1,066 through 1,080 (of 1,182 total)