Heh... in other words, "Duplicate post".  Thanks, Thom.

What is the default language for the server?

Except for the first insert into a table under some special conditions, INSERTs will always try to fill all pages to as near to 100% as possible according to the...

I just now rated the article 3 out of 5, because while it's well written, no discussion of very large table index maintenance would be complete without mentioning the...

You would fair much better if you provided readily consumable data.  Help us help you... See the first link in my signature line below for one way to create "Readily...

Interesting...  At the time of this post, there were 3 votes with an average of 3.67.  That might mean two 5's and a 1 or two 4's and a 3. ...

Thanks for a great article. I am not a performance tuning expert, but I have learnt enough here to be dangerous.

I don't want to be "that" guy and it...

I'm not sure where all of the talk about "NOLOCK" is coming from.  The method I demonstrated uses "TABLOCK".  The same holds true with "SNAPSHOT" and "MERGE".  None of that...

You can use an IDENTITY or SEQUENCE column as a temporal tie breaker.  But,  having the columns you mentioned and having the tied data in them, doesn't bode well for...

@ MVDBA ,

Awesome article.  Thanks for taking the time to research it and post it, especially since it's coming from someone that does have experience in both worlds.

Heh... so, inquiring...

The link to the MongoDB site apparently is case sensitive (!). It should be https://www.mongodb.com/nosql-explained.

Thanks for the article. Interesting read, especially in combination with the original one as...

True enough but all hell will break loose when you need to go to 4 "childs". 😉

I am not sure that Developer Edition is applicable here.  Jack the Cat talks about doing analysis of data. That smells production to me. And Developer Edition is not...

Also, see the following article that provides a method to solve for most things that you could as of an "Adjacency List" Hierarchy.

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

For future posts, please see the first link in my signature line below.  Producing "readily consumable" data,...