Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 59,067 total)

Reply To: What should I have done with this?

Too funny, Rick. What did it say on what would be the bottom of the box as it's oriented in the picture?
--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)

September 2, 2022 at 9:54 pm

#4083467
Reply To: Find replace using regular expressions

drew.allen wrote:
I believe that this does close to what you are looking for. It can probably be massaged to do exactly what you want. The big problem is that 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)

September 2, 2022 at 9:49 pm

#4083465
Reply To: How do I query to exclude the "first position of a 3 digit number"

I agree with Scott that such a query is going to return all the hotel rooms except "some" and will likely do a scan anyway. So, just keep it 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)

September 2, 2022 at 9:45 pm

#4083464
Reply To: Performance on large table -Index Creation
If you do build an index (non-clustered or clustered, doesn't matter) on the Unique Identifier column, build the index with a 71% Fill Factor and setup a job to...
- This reply was modified 3 years, 9 months ago by Jeff Moden. Reason: Forgot to specify the column
--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)
September 2, 2022 at 6:04 am

#4083125
Reply To: URGENT - Visio Diagram from SQL Server Database

Your answer is here...
https://www.google.com/search?q=reverse+engineer+a+database+using+visio
I believe it needs to be the "professional" version, though.

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

September 2, 2022 at 5:50 am

#4083121
Reply To: Potholes in the Road of Progress

How strange it is that this wonderful article resurface today. It's provided some much needed motivation. Thank you again for writing it, Phil.
--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)

September 2, 2022 at 4:40 am

#4083108
Reply To: Performance degradation - Help troubleshooting

Agreed on both.
--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)

September 2, 2022 at 1:05 am

#4083090
Reply To: How do I query to exclude the "first position of a 3 digit number"

Yes. That would work but how often would you actually have a need that couldn't be solve easily, like Phil did?
--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)

September 2, 2022 at 1:04 am

#4083089
Reply To: SQL Server 2022 Build List

Ah, sorry. This article is strictly about 2022. My mistake.
--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)

September 1, 2022 at 7:13 pm

#4083014
Reply To: How do I query to exclude the "first position of a 3 digit number"

aaron.reese wrote:
Agreed, which is why it should be stored as two separate fields. Could do it on the table with a couple of computed columns.
I guess I'd have to disagree,...
--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)

September 1, 2022 at 7:11 pm

#4083013
Reply To: Unlimited PTO

skeleton567 wrote:
larry.blake wrote:
Jeff Moden wrote:
What I'd really like to see are companies that stop punishing people for not taking time off. I've had more vacation just vanish because I had more...
--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)

September 1, 2022 at 6:57 pm

#4083004
Reply To: SQL Server 2022 Build List

You appear to be missing a few thinks under the production builds section. 😀 It shows up totally empty for me.
--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)

September 1, 2022 at 6:42 pm

#4082995
Reply To: Performance degradation - Help troubleshooting

Ken McKelvey wrote:
Have you actually had the hardware checked?
A hardware fault is the most likely cause of your problems and it could mean your server is about the fail completely.
I totally...
--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)

September 1, 2022 at 6:38 pm

#4082994
Reply To: Performance degradation - Help troubleshooting

The Performance Dashboard has an area for the most expensive queries. Have a look at those. Unfortunately, it doesn't tell you which part of some really long queries might be...
--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)

September 1, 2022 at 6:17 pm

#4082978
Reply To: SQL convert Rows to columns

wburke 85918 wrote:
Wow, that's a very good article Jeff, comparing Pivot to Cross Tabs. I was noticing all your Pivots always have aggregate functions. What I am doing seems to involve...
--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)

September 1, 2022 at 3:18 am

#4082671

Viewing 15 posts - 2,836 through 2,850 (of 59,067 total)