Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,701 through 5,715 (of 59,101 total)

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
Reply To: How to delete in small chunks

vsamantha35 wrote:
Hi Jeff,
Thanks for the options provided. One thing wanted to know, will both methods will take of Transaction log reuse right? meaning, rather than log file growing out 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 2:34 pm

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

Steve Jones - SSC Editor wrote:
the industry also has a track record of many improvements that are improvements. Hence my post. It's easy to be too negative or positive. I am striving for 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:37 am

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

It's a real shame that a lot of people writing software and user interfaces don't seem concerned with that balance. And I have to disagree with you... the industry has...
--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 5, 2021 at 11:49 pm

#3841744

Viewing 15 posts - 5,701 through 5,715 (of 59,101 total)