Jeff Moden

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 59,067 total)

Reply To: Am I doing the right thing, and what does this mean?

Although Ola's code has been branded as the "Gold Standard" by good people like Paul Randal, I won't use his code for index maintenance because it measures the wrong things...
--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 16, 2025 at 3:59 am

#4636238
Reply To: Determining the Updated Columns

COLUMNS_UPDATED() will tell you which columns had an update attempted but it will not tell you if a value actually changed.
Also, I'm in favor of the clarity of IF UPDATED(CreditLimit)...
--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 16, 2025 at 3:31 am

#4636228
Reply To: Getting the SQL

It returned some headers so none of the answers is actually correct.

--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 16, 2025 at 3:28 am

#4636219
Reply To: How to practice SQL server at home

skandala199 wrote:
Practice SQL interactively, https://www.sql-practice.online/ This is perfect for SQL interview prep. No signup required - just start practicing!
I have Norton Utilities and Global Protect running... one of them didn't...
--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 16, 2025 at 3:20 am

#4636218
Reply To: Do I need admin rights to import or create new database

Grant Fritchey wrote:
For example, if you were planning to use the "Import Data" wizard. That's there in 20, and prior, but not in 21
What on Earth are they thinking?
Lordy...
--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 13, 2025 at 2:45 pm

#4634959
Reply To: Direct Connection running Fast,Linked Server running Slow

Mr. Brian Gale wrote:
Just to add to the advice - I would advise against SELECT * unless it is absolutely necessary. The reason being if the source metadata changes (column added or...
--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 12, 2025 at 10:17 pm

#4634619
Reply To: A Little Appreciation

I have to give Steve a huge amount of credit for my success... he's kept this site going and he encouraged me to write articles. This site was also 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)

August 9, 2025 at 9:53 pm

#4633257
Reply To: Direct Connection running Fast,Linked Server running Slow

892717952 wrote:
However, when the query SELECT * FROM LS01.DB01.dbo.vwA is executed directly on Server B (targeting the linked server), the same operation takes approximately 50 seconds to complete.
We had similar...
--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 9, 2025 at 9:25 pm

#4633242
Reply To: Working with Indexes on SSMS

Mr. Brian Gale wrote:
In some cases, indexes can hurt SELECT performance. .
Do you have a link on that subject?
--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 9, 2025 at 3:05 am

#4632985
Reply To: How to optimize queries using AI (SQL Expert)
Heh... all that and it still left a temporal BETWEEN instead of using the more correct and bullet proof "Closed/Open" comparison method...
```
... 
  WHERE soh.OrderDate >=...
```
--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)
July 28, 2025 at 9:15 pm

#4627978
Reply To: Comparing one record within a SELECT SUM()
Pete Bishop wrote:
SELECT SUM([value]) AS [value], {some magic code} FROM [table1]
value is_processed
39.6 Y
```
--===== Because 'Y' is greater than 'N', this works.
 SELECT...
```
--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)
July 28, 2025 at 9:03 pm

#4627977
Reply To: In Praise of Simplicity or The Power of Plain Language in a Buzzword World

THIS!!! (from the article)...
Plain language isn’t a lack of sophistication; it’s a sign of mastery.
--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)

July 22, 2025 at 3:59 pm

#4625777
Reply To: Formatting Dates and Times: The SQL Dialect Divide

Just a bit of a sidebar... avoid using FORMAT except for maybe 1 row displays. Performance of FORMAT is absolutely horrible even compared to relatively complex CONVERTs. Here's an article...
--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)

July 22, 2025 at 3:52 pm

#4625773
Reply To: The Long Weekend

Heh... I'm with ya. My git'up'n'go has got up and went. Hope you had a pleasant weekend, Grant.

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

July 6, 2025 at 11:08 pm

#4618533
Reply To: Independence Day

The missing 5th choice, of course...
"All of them"
Happy Independence Day to all!
--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)

July 4, 2025 at 12:08 am

#4617313

Viewing 15 posts - 61 through 75 (of 59,067 total)