Forum Replies Created
Viewing 15 posts - 7,201 through 7,215 (of 59,072 total)
-
Reply To: Select return no records
jcelko212 32090 wrote:>> Now it is you that is putting words in my mouth. ?? That's not what I said. <<
No I think you misread, this principle is from Brent Ozar....
-
Reply To: Are the posted questions getting worse?
Wow... just freakin' WOW!!! I thought that continuous integrationist and deployment was supposed to prevent this type of thing.
The first paragraph (quoted below) is what is really shocking to...
-
Reply To: Select return no records
mosaic-287947 wrote:I completely agree with Celko.
Heh... being stuck with character-based identifiers due to a legacy system is one thing. Arbitrarily saying that all identifiers should be character-based because they're not...
-
Reply To: Representing XML data in SQL Server
Heh... I've got just one more thing to add when it comes to the transfer of large volumes of properly formed tabular data...
-
Reply To: Parent-Child Hierarchy - Finding the root
-
Reply To: Parent-Child Hierarchy - Finding the root
jcelko212 32090 wrote:I've written an entire book on various methods for modeling treason hierarchies and SQL. Get a copy and see which technique is most appropriate for your particular situation.
I'll add...
-
Reply To: Parent-Child Hierarchy - Finding the root
Steve Collins wrote:Imo expressing the recursive "downlines" or "sort path" as nested json makes the information much more usefully accessible. You can check out an example at:
Can you use the "Sort...
-
Reply To: Parent-Child Hierarchy - Finding the root
p.s.
If you want to seem some "Black Arts" magic with these kinds of Adjacency List hierarchies and learn about Nested Sets and other cool things, check out the following two...
-
Reply To: Parent-Child Hierarchy - Finding the root
It can be done in using a single recursive cte. You just need to pass the first found roots to the rest of the hierarchy. We might as well sort...
-
Reply To: EF Code-First
Eirikur Eiriksson wrote:CF normally doesn't stand for Code First, it is rather a notation of a Cluster Fxxk, but then again that would be the same thing
😎
Heh... I'll remind you that...
-
Reply To: A Remote Work Guide
Chris Harshman wrote:Now I find out about things later and wonder why they did it that way.
We all know the reason, though, right? It's the same reason why we sit in...
-
Reply To: EF Code-First
EFCF is great if you want everything to be NVARCHAR(256) and even True/False columns to be NUMERIC(18,0). That's great for the economy, as well, because it keeps a raft of...
-
Reply To: Link Server
mariomoyeda wrote:Hello All,
thank you all for your contributions.
The problem was resolved.
Two way street here... 😉 Please tell us what you did to resolve the problem.
-
Reply To: A Remote Work Guide
I have to say that I'm loving the isolation (of course, I don't have kids at home and I don't like the reason for the isolation). Not much has changed...
Viewing 15 posts - 7,201 through 7,215 (of 59,072 total)