Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,686 through 5,700 (of 59,089 total)

Reply To: Allow SQLSaturdays to personalize

codegumbo wrote:
This may seem insignificant in light of all of the decisions that need to be made about the future of events, but one of the things that was always...
--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)

February 8, 2021 at 2:09 pm

#3842487
Reply To: Do it. Try it. Fix it.

Yep... that's the way it is... not the way it should be. That's exactly what I'm talking about. That junk methodology needs to be fixed.
--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)

February 7, 2021 at 12:00 am

#3842022
Reply To: Moving Items into Columns

If you post your data in a readily consumable format, you're more likely to get a coded answer for this. Please see the first link in my signature line below...
--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)

February 6, 2021 at 11:44 pm

#3842019
Reply To: Evaluating Amazon RDS Instance

IIRC, you have no control over backups and, if you want a single database to be restored, you have to request that the whole instance be restored.
Unless you want almost...
--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)

February 6, 2021 at 11:37 pm

#3842018
Reply To: Are the SQL Server "Error Logs" (residing under SQL Server Agent) backed up?

Instead of farting around with files, build a database to hold the error logs in tables and do something like what the fellow at the following link did.
https://www.mlakartechtalk.com/how-to-load-sql-server-error-log-into-table-for-analysis/
You could...
--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)

February 6, 2021 at 11:16 pm

#3842014
Reply To: Do it. Try it. Fix it.

Sergiy wrote:
F.clems, if you need to use tricks and manipulation to bypass the system in order to get a good result, then the system is broken, don't you think?
Totally agreed. ...
--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)

February 6, 2021 at 9:51 pm

#3841994
Reply To: Do it. Try it. Fix it.

Sergiy wrote:
Jeff, what you describe is the essence of Agile Development, as it's done nowadays.
to fix the quality of software product the industry has to outlaw terms "agile", "sprint", etc.
You...
--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)

February 6, 2021 at 9:46 pm

#3841993
Reply To: Do it. Try it. Fix it.

I've had many managers in the past 20 years. Some were good, some not so good, and some were terrible. The not-so-good ones can sometimes be "trained" through demonstration of...
--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)

February 6, 2021 at 9:37 pm

#3841991
Reply To: How to remove NULLs from Query Result

carlton 84646 wrote:
Hey Jeff,
Thanks for the lesson.
And this is very nice. I missed the option to do
WHERE city in ('Arizona','California','Hawaii')
Also, not entirely sure how this line works
SELECT ByCityFirstNameID = ROW_NUMBER() OVER...
--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)

February 6, 2021 at 9:10 pm

#3841980
Reply To: How to remove NULLs from Query Result

BWAAAAA-HAAAAA-HAAAA!!! See? As predicted including the rubbish about how "identifiers can't be numeric". 😀
--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)

February 6, 2021 at 9:03 pm

#3841979
Reply To: How to remove NULLs from Query Result

Yes...
To be sure, the "WITH" that you speak of is called a "CTE", which stands for "Common Table Expression". In many cases, you can simply move such things to 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)

February 6, 2021 at 4:34 pm

#3841934
Reply To: Do it. Try it. Fix it.

To be sure, my rant on this subject isn't directed towards anyone in particular, especially the poor ol' developers (I used to be a front-end developer a long, long time...
--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)

February 6, 2021 at 4:20 pm

#3841923
Reply To: How to remove NULLs from Query Result

p.s. Since Joe Celko is one of my "followers" (and this site won't allow me to reject certain people as "followers" 🙁 ), if he shows up with his normal...
--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)

February 6, 2021 at 4:07 pm

#3841921
Reply To: How to remove NULLs from Query Result

Man-o-Man, Carton! Nice job on the DDL and test data. It ran perfectly and made my life a whole lot easier to help. Very well done.
Here's one fairly easy answer...
--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)

February 6, 2021 at 3:51 pm

#3841919
Reply To: Do it. Try it. Fix it.

f.clems wrote:
It may all come done to the interpretation, but this cycle seems perfectly relevant.
Do it: get the first draft implementation. I'm to often locked in meeting on how should...
--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)

February 6, 2021 at 3:03 pm

#3841913

Viewing 15 posts - 5,686 through 5,700 (of 59,089 total)