blake 81053 (2/26/2016)

---

Well ... [highlight="#ffff11"]you could completely avoid built-in operators[/highlight] that are designed specially to answer the question that you are seeking to solve ... or you could do it...

Two points

1. COUNT(*) and IS NULL are built in operators/functions.

2. Your query did not provide the results as expected by the original query.

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);

SELECT

COUNT(*) AS A,

...

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. ...

I believe the...

I've encountered some devs, even myself at times, that would be considered celery - negative calories!

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 -...

For hierarchies of < 50 levels depth, Nested Intervals (Hazel) may be of interest.

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,...

Jeff,

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...

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.

TIA

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...

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...

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...

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...