Viewing 15 posts - 1 through 15 (of 20 total)
blake 81053 (2/26/2016)
February 26, 2016 at 10:16 am
1. COUNT(*) and IS NULL are built in operators/functions.
2. Your query did not provide the results as expected by the original query.
February 26, 2016 at 9:30 am
Try this code:
CREATE TABLE #test (id int);
INSERT INTO #test (id) VALUES (1);
INSERT INTO #test (id) VALUES (2);
INSERT INTO #test (id) VALUES (NULL);
COUNT(*) AS A,
February 26, 2016 at 6:49 am
Lest we (as DBA's) forget, MongoDB uses JSON. Move the parsing to an app server and store it as columns in tables in SQL Server of any version. ...
September 10, 2015 at 11:06 pm
nycdotnet (6/18/2013)Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon".
I believe the...
June 4, 2015 at 8:56 am
I've encountered some devs, even myself at times, that would be considered celery - negative calories!
March 18, 2015 at 4:09 am
I believe there is an error in this function with regard to F to C & C to F conversions. Try some well known values like:
32F to C -...
December 18, 2014 at 11:13 am
For hierarchies of < 50 levels depth, Nested Intervals (Hazel) may be of interest.
August 21, 2012 at 11:10 am
The URL to Hazel's method: http://arxiv.org/PS_cache/arxiv/pdf/0806/0806.3115v1.pdf
The "overall" was in reference to HierarchyID. However, Nested Intervals outperformed Nested Sets in everthing related to non-leaf node (insertion,...
August 1, 2011 at 7:52 am
I have tested the HierarchyID and associated functions against Adjacency Lists using CTE's, Nested Sets (a la Celko) and Nested Intervals (Hazel's implemetation) and found it to be lacking in...
August 1, 2011 at 5:43 am
Is there a possibility of getting the scripts / slide content? There was a slide that flashed by during the presentation but my copy/paste reflexes didn't keep up.
July 9, 2010 at 9:08 am
Well done! A very informative and well presented comparison of the various mechanisms of implementing UDF's. I guess that means I have some work to do...
July 6, 2010 at 11:07 am
That is correct, it is only executed "from" one node but it actually executes on both. In order to do that it copies all of the files necessary to...
July 6, 2009 at 1:55 pm
Take a look here: http://tp.its.yale.edu/pipermail/cas/2005-July/001335.html
From the CREATE LOGIN statements it appears that neither your AD nor master db is case-sensitive. If you are not creating an...
November 9, 2007 at 5:17 am
Hmmm... Well, I'm stumped. I can't think of anything else that might be hindering the restore. If I think of something, I'll post again. Sorry I couldn't be of more...
September 22, 2004 at 10:59 am