Jeff Moden

Forum Replies Created

Viewing 15 posts - 586 through 600 (of 59,069 total)

Reply To: The DBAccountant

Ross McMicken wrote:
Jeff Moden wrote:
I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all 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)

May 9, 2024 at 3:38 am

#4419946
Reply To: ghost backups processed 0 pages

Snargables wrote:
I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages...
--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)

May 8, 2024 at 7:41 pm

#4419877
Reply To: Inserting 100K rows Performance - Baseline Performance

I think that maybe the HammerDB code you ran in the other thread is a better tell.
--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)

May 8, 2024 at 7:32 pm

#4419874
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Jeff Moden wrote:
Dear Steve Jones...
I forget how long it's been since this site was moved to WordPress but it's been a long time. Those of us long-timers that are left...
--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)

May 8, 2024 at 7:08 pm

#4419871
Reply To: Are IT Certifications Still Relevant?

david.gugg wrote:
I've never attempted any certifications and I've never missed out on a job because of it. I don't see the value, but as a learning tool it is probably...
--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)

May 8, 2024 at 6:49 pm

#4419859
Reply To: The "ORDER BY" clause behavior

Nice question, Alessandro. Proof, yet again, that SQL <> SQL and that the basic training out there isn't working 😉
--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)

May 8, 2024 at 6:13 pm

#4419847
Reply To: Are the posted questions getting worse?

Dear Steve Jones...
I forget how long it's been since this site was moved to WordPress but it's been a long time. Those of us long-timers that are left (not many...
--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)

May 8, 2024 at 3:48 am

#4419628
Reply To: Are the posted questions getting worse?

Shop size doesn't matter to me. What matters is the attitudes of management on both the Dev and Database sides of the house and the attitudes of the folks 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)

May 8, 2024 at 3:44 am

#4419627
Reply To: some questions related to Ola hallengren maintenance scripts

MMartin1 wrote:
Jeff Moden wrote:
vsamantha35 wrote:
Hi All,
I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply.
1. In which order the rebuild and update stats...
--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)

May 8, 2024 at 3:33 am

#4419624
Reply To: The DBAccountant

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the "I told...
--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)

May 8, 2024 at 3:15 am

#4419619
Reply To: Multi row tally query with max value

Ok... I had a look. First, I've got to say I don't know why supposed scientists are willing to lose data by rounding it. Whatever.
Looking back at this thread, Jonathan...
--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)

May 8, 2024 at 3:08 am

#4419618
Reply To: Multi row tally query with max value

@ibbo14,
I've grown to trust more in zip files being benign and like them a whole lot better than having to go to some other site to get them. Still, there...
--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)

May 8, 2024 at 1:51 am

#4419608
Reply To: Are IT Certifications Still Relevant?

To be honest, certifications were never relevant to me. I was considering becoming certified 2 decades ago but then I ran into two people that were working for the same...
--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)

May 8, 2024 at 1:25 am

#4419605
Reply To: Knowing What You Don’t Know

Eric M Russell wrote:
Sharing what we think we know with others (external validation) is a good way to learn what we didn't know before. Even the "resident SQL Server expert" in an...
--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)

May 8, 2024 at 12:16 am

#4419595
Reply To: SQL-CTE reqursive query

Last but not least... your the one that will need to " 'splain'n'maintain" this... do you understand how it all works?
--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)

May 7, 2024 at 11:59 pm

#4419594

Viewing 15 posts - 586 through 600 (of 59,069 total)