Viewing 15 posts - 16 through 30 (of 31 total)
Why not just sqlclr + any of the brazillion c# expression parsers?
https://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=c%23+math+expression+parser&pbx=1&oq=c%23+math+express&aq=0&aqi=g2g-C1g-jC1&aql=&gs_sm=e&gs_upl=0l0l1l79l0l0l0l0l0l0l0l0ll0l0&bav=on.2,or.r_gc.r_pw.r_cp.,cf.osb&fp=ea0e067728996111&biw=1231&bih=652
More generally, why chew up db cycles (affecting all db users) with this at all, rather than...
November 21, 2011 at 10:56 am
Irony: Just the other day this site was telling me "Don't Criticize Code", because it might hurt someone's fee-fee's.
November 17, 2011 at 11:18 am
I get this too sometimes even when there are no date cols anywhere in any select. HIGHLY annoying.
October 2, 2011 at 9:02 pm
This is the typical reference I've seen passed around on how to use dynamic sql well. http://www.sommarskog.se/dynamic_sql.html
October 2, 2011 at 8:06 pm
Wouldn't another factor in the lessening of books on sql be that it's a mature technology, which hasn't changed all that much in 30 years?
I mean really, select-from-where-groupby is the...
August 7, 2011 at 6:31 pm
Hah. I never knew what the in-process checkbox was for, on the provider properties, only that I had to check it, in order for the linked server to actually work....
June 8, 2011 at 11:16 pm
Distance on a plane, or distance on a sphere? If locations are far-ish apart, it makes a difference.
May 26, 2011 at 2:23 pm
Craig-315134 (5/9/2011)
I do have what I hope isn't a 'stupid question', please. To be a competent SQL Server DBA, how good should my T-SQL skills be?...
May 9, 2011 at 2:10 pm
Koen: Thanks for the pointers to relevant certs.
I think one reason I haven't yet jumped into the cert game is that it appeared to me from the outside like they...
May 9, 2011 at 11:42 am
re: certs - what would be a good one or ones to get?
Me: Street programmer, dotnet/sql, got advanced degree in math, put the word "programmer" on my resume, and have...
May 8, 2011 at 11:33 pm
I'm no sql genius or anything, but is anyone concerned that the poster apparently has 2+ versions of the truth running around in his or her database?
Besides the technical detail...
November 27, 2009 at 4:45 pm
Bob Hovious 24601 (11/26/2009)
November 26, 2009 at 2:47 pm
sknox (10/27/2009)On a serious note, sometimes programming isn't about performance, or even about successfully accomplishing a task, but about learning.
"Learning" also encompasses choosing a more appropriate platform/language to implement desired...
October 27, 2009 at 11:11 am
With all iterative linear algebra code, the primary considerations are speed and numerical stability. Code maintainability can also be an issue.
What benefits are there on these fronts to doing the...
October 27, 2009 at 11:08 am
Viewing 15 posts - 16 through 30 (of 31 total)