Viewing 15 posts - 301 through 315 (of 938 total)
Wyatt Eurich (5/12/2008)
I prefer a computer to do what I tell it to do, right...
May 12, 2008 at 7:50 am
Rebecca Lovelace (5/12/2008)
Also, Mother and mother do have 2 different meanings in English (Mother is the proper noun, and mother is just a noun).
But what does "mOtHeR" mean? Teehee
May 12, 2008 at 7:17 am
Jeff Moden (5/11/2008)
May 11, 2008 at 12:30 pm
yohannn (5/11/2008)
May 11, 2008 at 9:58 am
emiles01 (5/10/2008)
...there must be something of value to the choice of case sensitivity, especially since it also has a cost.
Speed and simplicity. Case, accent, kana, and other insensitivities cost...
May 11, 2008 at 12:07 am
Just FYI, I recently posted an MS Connect feedback item on this very topic, asking for a case-sensitivity option in SSIS Data Flow components: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=339069
The thinking is that even if...
May 10, 2008 at 4:14 pm
Confucius247 (4/30/2008)
Mike C (4/29/2008)
Table-Valued Functions.And if that were what we were talking about...
My attitude with functions is avoid like the plague, as they break the rule of thinking in sets...
April 30, 2008 at 7:35 am
Confucius247 (4/29/2008)
My attitude with functions is avoid like the plague, as they break the rule of thinking in sets while programming SQL.
Table-Valued Functions.
April 29, 2008 at 2:37 pm
Peso (4/25/2008)
No need to invoke CLR (only if you want greater speed).Free RC4 encryption here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76258
Free MIME64/BASE64 encoding here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67831
Free ROT algorithm herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67752
Thanks for the links! Actually the XP's here don't...
April 27, 2008 at 10:08 pm
Hi Wayne,
There are some interesting issues surrounding the bigint data type, but I don't know why it would be giving you results so out of whack. I'll look into...
April 27, 2008 at 10:04 pm
Hey Charles,
I haven't had an opportunity to test on compact editions (mostly because I don't have access to any right now). It does sound like an interesting idea though,...
April 27, 2008 at 10:02 pm
Hi jpachman,
Sorry I didn't see your post sooner. I only tested on SQL 2000 SP 4, and it looks like (from the version number you gave) that you're running...
April 27, 2008 at 9:59 pm
rippleshah (4/5/2008)
I've started reading your article and am not clear why the query: SELECT COUNT(region) FROM Suppliers WHERE Region IS NOT NULL returns 0
1. WHERE clause eliminates every row in...
April 5, 2008 at 5:00 pm
dbishop (4/4/2008)
Not BIG on DBA, but the only question I have with your code:
SELECT ...
FROM ...
WHERE COALESCE(DateTo, Today) >= Today
is, if DateTo is an indexed column, wouldn't wrapping it in...
April 4, 2008 at 2:44 pm
Viewing 15 posts - 301 through 315 (of 938 total)