Jeff Moden

Forum Replies Created

Viewing 15 posts - 271 through 285 (of 59,069 total)

Reply To: The Funny SELECTs

It's also going to miss any and all "whole dates" (a.k.a. dates with a midnight time) for the 3 years involved. The > should have been >= in all 3...
--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)

December 2, 2024 at 2:05 am

#4491880
Reply To: Over-Engineering

skeleton567 wrote:
Several years after that my old boss related to me that the bug fixes had never been released, and the whole system had been retired and replaced.
Ya just gotta...
--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)

December 1, 2024 at 10:48 pm

#4491844
Reply To: Simple Junction table design question

ScottPletcher wrote:
I believe the more common, and better, naming for tables is plural. I can't think of a major relational dbms that uses singular system table names.
For example: sys.objects (SQL...
--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)

November 30, 2024 at 5:32 pm

#4491356
Reply To: Simple Junction table design question

eichnerm wrote:
Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I...
--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)

November 27, 2024 at 4:08 am

#4489649
Reply To: Microsoft Recommendations for Update Stats?

Brandie Tarvin wrote:
Wow. Just ... WOW. Watched the 1.2. Now going to watch 3.
Thanks, Jeff.
That's the same reaction I had when the size charts gave me a hint about what was...
--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)

November 27, 2024 at 12:28 am

#4489610
Reply To: Microsoft Recommendations for Update Stats?

Bumping my own post because of the 2nd page issue on this forum.

--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)

November 26, 2024 at 11:59 pm

#4489597
Reply To: Microsoft Recommendations for Update Stats?

Brandie Tarvin wrote:
Oh, and can I get a favor? Can everyone to update their posts with the proper spelling of my name? Brandie.
Sorry and done.

--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)

November 26, 2024 at 11:58 pm

#4489596
Reply To: Microsoft Recommendations for Update Stats?

It's free. Like it says in the presentation, send me an email to the email address I provided and I'll send you the zip file that I give folks when...
--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)

November 26, 2024 at 11:53 pm

#4489595
Reply To: Rebuild Index Job on a Large DB

Heh... "It's Shake'n'Bake and I helped"! 😀
--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)

November 26, 2024 at 11:49 pm

#4489593
Reply To: Disable "Database Maintenance Plan"

shahriarplus wrote:
Hi Dig , You should disable all your MaintenancePlan related jobs in "sql server agent" .
Welcome but, if you're going to say something like that, you should explain why...
--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)

November 25, 2024 at 6:09 am

#4488650
Reply To: Black Friday 2023

Happy Thanks Giving to you as well, Rick and to all the denizens of SSC.
--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)

November 25, 2024 at 6:00 am

#4488642
Reply To: Computer Algebra

Heh,... thanks for the feedback, Steve. It was a story that explained that if you "know the gazintas, anything is possible"... even in SQL. And, it was actually really simple...
--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)

November 25, 2024 at 3:02 am

#4488607
Reply To: Microsoft Recommendations for Update Stats?

Brandie Tarvin wrote:
I disagree with "stop rebuilding indexes." The quote you provided doesn't seem to support that statement if I take it as is, no caveats.
Regardless, we already have regular checkups...
--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)

November 24, 2024 at 8:51 pm

#4488536
Reply To: What is the best index strategy for a table that gets truncated?
For Minimal Logging on a Table with a Clustered Index. Note that at least one of these is missing from the documentation but absolutely required to make Minimal Logging work.
--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)
November 24, 2024 at 8:25 pm

#4488534
Reply To: Black Friday 2023

I would like to have a 4 day Thanksgiving weekend where no one needed help doing something.
--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)

November 24, 2024 at 7:49 pm

#4488527

Viewing 15 posts - 271 through 285 (of 59,069 total)