Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 59,099 total)

Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
Ummm... ok. Why not the best of both worlds instead of "upset everyone"?
If you mean add some relational stuff to the WP document store, I'm tempted. I think...
--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 30, 2022 at 3:53 pm

#4131943
Reply To: Best primarykey and index

ScottPletcher wrote:
To be absolutely clear, you want a:
2) unique clustered [index] on (tenant,year,id)
And if you partition the data (which typically wouldn't be necessary here), partition it by (tenant, year) not...
--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 30, 2022 at 3:39 pm

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

Steve Jones - SSC Editor wrote:
Grant's book: https://www.amazon.com/Server-2022-Query-Performance-Tuning/dp/1484288904/ref=sr_1_3?crid=3I1VV0HSNHD4T&keywords=grant+fritchey&qid=1672333097&sprefix=grant+fritche%2Caps%2C159&sr=8-3&ufe=app_do%3Aamzn1.fos.006c50ae-5d4c-4777-9bc0-4513d670b6bc
Thanks, Steve.
--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 29, 2022 at 6:16 pm

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

Steve Jones - SSC Editor wrote:
I've logged quite a few bugs lately on things. We've got a test site setup for an upgrade to PHP/WP/Nami, which is delaying work on other bugs. The upgrade...
--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 29, 2022 at 6:14 pm

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

Bloody forum software did it again... since the post I just posted is the first one on a new page, it's not showing up until I make another post. 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)

December 29, 2022 at 4:41 pm

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

Grant Fritchey wrote:
I show an example in the query tuning book where defragmentation improves performance because of a scan, fewer pages read. I also explain all the reasons why, this 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)

December 29, 2022 at 4:38 pm

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

Thanks, Greg. I have to admit I took it wrong way a bit and so was just making sure. And I love both of your examples.
As a bit of 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)

December 28, 2022 at 10:28 pm

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

Thanks for the "faith" and thank you for the incredible feedback.. Our buddy, Ed, did the same thing with similar results after I told him what I'd found, especially concerning...
--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 28, 2022 at 9:25 pm

#4131253
Reply To: Proper CASE statement

You do realize that your graphic has the S1SDat column listed 3 times, right? Is there a similar problem with the rest of the code that you've not displayed?
Also, do...
--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 28, 2022 at 9:14 pm

#4131251
Reply To: SQL on Hyperv

Jo wrote:
External company makes remarks that the server is the issue or could be the issue.
This is easy then... have a video meeting where you drive and they tell 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)

December 28, 2022 at 9:03 pm

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

Thanks for the response, Greg. I appreciate it.
I wasn't asking if anyone knew of an article that proves the "benefits" of doing Index Maintenance to figure out a way to...
--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 28, 2022 at 8:24 pm

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

Michael L John wrote:
Jeff Moden wrote:
BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.
https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html
He also was only testing 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)

December 28, 2022 at 5:34 am

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

And, then again, NOT! It turns out that he was testing fragmentation on spinning rust. Not logical fragmentation of a index. [headdesk] 🙁
--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 28, 2022 at 1:34 am

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

BWAAA-HAAA-HAAA. Posting on this thread must cause disturbances in the "force". I looked again right after I posted and I finally found one.
https://gertjans.home.xs4all.nl/sql/fragmentation-hurts-performance.html

--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 28, 2022 at 1:05 am

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

There's no question in my mind that I've lost my mind 😀 and I'm not sure if I've asked it here before or not but I'll ask it again.
Other than...
--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 28, 2022 at 12:22 am

#4130857

Viewing 15 posts - 2,221 through 2,235 (of 59,099 total)