Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,846 through 19,860 (of 59,072 total)

RE: Nope to NoOps, No way to NoDBA

Phil Factor (8/15/2015)
It sounds like you've worked at the same places I have.
Side by side a pond apart, ol' friend. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 17, 2015 at 8:07 am

#1820445
RE: Nope to NoOps, No way to NoDBA

David.Poole (8/17/2015)
If you want to understand how something works try and change it.
I've been playing around with NOSQL for long enough to know that if you choose the right tool...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 17, 2015 at 8:05 am

#1820443
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

Jeff Moden (8/17/2015)
serg-52 (8/17/2015)
sqlserverstarter (8/16/2015)
To your questions: the slug_en can contain duplicates, but never within the same hierarchy, so "pillows" could occur multiple times but will always have a different...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 17, 2015 at 7:57 am

#1820439
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

serg-52 (8/17/2015)
sqlserverstarter (8/16/2015)
To your questions: the slug_en can contain duplicates, but never within the same hierarchy, so "pillows" could occur multiple times but will always have a different parentid.
Based on...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 17, 2015 at 7:31 am

#1820428
RE: Mission Critical Deployments

I'm always amazed that people don't pay attention until someone gets hurt or dies. This appears to be the same mentality that prevails in every day code. They...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 17, 2015 at 12:49 am

#1820360
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

The following code will work as requested against the data you posted. It uses 144 logical reads because of the recursive CTEs and takes 1 to 5 ms duration....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 10:23 pm

#1820353
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

sqlserverstarter (8/16/2015)
Ah, makes sense now 🙂
Based on my total set of data I'd say that your suggestion to
recursively find all the children of the top level parent and then...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 9:33 pm

#1820351
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

What I meant was that the answer to all the possible questions must already be present in the data or we'll be stuck with double (or more) recursion. Recursion...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 7:00 pm

#1820347
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

Then you need to know the answer to the question before the question is known. Sorry, don't mean to sound cryptic but it's true and I can demonstrate how...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 6:37 pm

#1820344
RE: Recursively select records in single table when having main categoryid and textvalue of subcategory

Do you have any other entries in your table that have a ParentID of "0"?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 6:17 pm

#1820342
RE: SQL Joins Question

Eirikur Eiriksson (8/16/2015)
Jeff Moden (8/16/2015)
Eirikur Eiriksson (8/16/2015)
Jeff Moden (8/16/2015)
Gosh, I'd be real careful here, Eirikur. While your good code certainly does what was asked, it will fail if table...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 1:09 pm

#1820339
RE: query help

Yep. Exactly what I was talking about. That uses recursive CTEs and is going to be slower and more resource intensive over time, especially if you have a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 1:07 pm

#1820338
RE: How many environments?
Steve Jones - SSC Editor (8/14/2015)
David.Poole (8/14/2015)
Local Dev
Continuous Integration
Functional test
Non-functional test (stress testing, penetration and vulnerability testing etc)
User acceptance testing
Showcase and demonstration
Production
Disaster Recovery
Wow, that's a lot, though I assume DR...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
August 16, 2015 at 12:10 pm

#1820337
RE: SQL Joins Question

Eirikur Eiriksson (8/16/2015)
Jeff Moden (8/16/2015)
Gosh, I'd be real careful here, Eirikur. While your good code certainly does what was asked, it will fail if table SampleData2 is ever correctly...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 11:43 am

#1820335
RE: Metrics Table or Performance Tuning

nick.latocha (8/16/2015)
This could be where we are going wrong. We have clustered the unique ID column. Let me try this out on our development environment.
You really need to post the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

August 16, 2015 at 11:30 am

#1820333

Viewing 15 posts - 19,846 through 19,860 (of 59,072 total)