Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 59,086 total)

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
Reply To: How do I query to exclude the "first position of a 3 digit number"

aaron.reese wrote:
So with my Joe Celko hat on 🙂
Is Room Number a numeric value or not? Most people would say yes, but in fact I would say no. The reason...
--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:10 am

#4082670
Reply To: Is It Possible to Join a Table-Valued Function w/Param To DB table

If your "TVF" has the word BEGIN in it, that'll make a world of hurt no matter how you're using it. That would make it an mTVF (Multi-statement Table Valued...
--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 2:05 am

#4082665
Reply To: Add another column with some commands

I guess I don't understand why you need to do this. The role grants those privs. Why do you want/need to do it separately?
--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 1:50 am

#4082660
Reply To: Unlimited PTO

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 on the books...
--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 1:32 am

#4082657
Reply To: Clustered Index leaves a lot of empty space

ScottPletcher wrote:
Here's a sample table and the corresponding view, with one non-nullable datetime and one non-nullable int column that have placeholder values that return NULL when querying the table.
For now,...
--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 1:25 am

#4082656
Reply To: Find replace using regular expressions

I've done some things using the "RegEx" button (which is a serious misnomer of it's own) on Search'n'Replace in SSMS but nothing like this. I can see other uses for...
--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)

August 30, 2022 at 8:20 pm

#4082156

Viewing 15 posts - 2,866 through 2,880 (of 59,086 total)