Viewing 15 posts - 1,066 through 1,080 (of 1,187 total)
PS - I ran DBCC USEROPTIONS in a database on our SQL Server 2005 server and got these results for the ANSI_NULLS and ANSI_WARNINGS options:
Set Option Value
ansi_warnings SET
ansi_nulls SET
Does that mean that these...
June 11, 2007 at 1:36 pm
Ah, yes, that makes sense.
Thanks for pointing that out. 🙂
webrunner
June 6, 2007 at 3:07 pm
I know we focus on db's here, but I think there is more call for browser portability these days than anything, and look at the pain that can result from...
June 1, 2007 at 7:35 am
Hello Igor,
You are right
a) I got under impression that you meant that it is a bug in SQL Server
b) by "scalability" I meant that your code is not...
May 31, 2007 at 1:14 pm
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
Viewing 15 posts - 1,066 through 1,080 (of 1,187 total)