Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,261 through 1,275 (of 59,082 total)

Reply To: Small Changes, Big Results

I agree.. small changes in knowledge are easier to learn and remember than trying to learn everything at once. I've also learned that, instead of learning how to solve 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 6, 2023 at 5:30 pm

#4254245
Reply To: Best way to track what user/logins are accessing a linked server

I Googled the following...
What is the best way to track down what users\logins are accessing my linked servers in sql server?
It came up with a lot of answers. Just 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 6, 2023 at 5:14 pm

#4254242
Reply To: Why would user account authentication issues arise in Azure?

I think all of this cloud stuff is a bit odd. It's actually very old thinking. Remember when people thought you were stupid if you didn't "decentralize" so that 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)

August 3, 2023 at 6:14 pm

#4252139
Reply To: Best way to handle incremental duplicate data in SQL Server?

SCDs (specifically, type 6 Slowly Changing Dimensions) would work the best. One of the better SCD methods is System Versioned Temp Tables.
https://en.wikipedia.org/wiki/Slowly_changing_dimension
I would avoid the use of a simple "IsCurrent"...
--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 2, 2023 at 11:37 pm

#4251426
Reply To: Ola Index Maintenance won't work on msdb

Just posting so Michael's post above will show up. This site won't show a single post on page 2. I really wish they'd fix that. 🙁

--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 2, 2023 at 8:55 pm

#4251330
Reply To: Constitutional AI

After reading this, I had this vision of the very old "graphic" of a snake eating its own tail.

--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 2, 2023 at 6:43 pm

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

Steve Jones - SSC Editor wrote:
I hate rebrands/renames. I think it creates confusion and often doesn't make anything better. Either you execute well or you do not and people know that, regardless of name.
However,...
--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 1, 2023 at 6:54 pm

#4250338
Reply To: Ola Index Maintenance won't work on msdb

andreas.kreuzberg wrote:
Good morning,
I am able to rebuild this index. And thats the problem, when I could rebuild the index, why wouldn't the Ola script rebuild the index?
I thinks, this is...
--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 1, 2023 at 6:44 pm

#4250336
Reply To: SQL Server 2024 or 2025?

Tom Uellner wrote:
November 13, 2025
That was going to be my guess and for the same 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)

July 31, 2023 at 6:31 pm

#4249403
Reply To: Ola Index Maintenance won't work on msdb

@ Andreas,
How are you verifying the fragmentation on that table after you've executed the OLA script?
Also, Michael's question is valid... your answer might be "to defragment the bloody index!" but...
--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 31, 2023 at 6:28 pm

#4249377
Reply To: Append MMYYYY to File to Copy

Jason A. Long wrote:
I don't see where anyone has already said it, so I'll say it… “MMYYYY” is a date format to avoid. Using “YYYYMM” instead will allow you to actually sort...
--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 30, 2023 at 8:19 pm

#4248600
Reply To: SQL Query

Steve Collins wrote:
If performance is a requirement then yes it could be refactored
Understood. For me, performance is 2nd only to a correct result... and its a very, very close second and...
--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 30, 2023 at 6:11 pm

#4248528
Reply To: Append MMYYYY to File to Copy

Everyone says that PowerShell is an essential skill for the modern DBA... bumping this for Bruin to give people the opportunity to demonstrate that skill. 😀
ZZartin did make a submission...
--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 27, 2023 at 3:13 pm

#4246053
Reply To: SQL Query

@steve-2 Collins,
I'm still interested in the ChatGPT prompt that you used to generate the populated test table because it'll help people understand how to use ChatGPT to do such 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)

July 27, 2023 at 3:09 pm

#4246051
Reply To: SQL Query

For anyone that wants to do a little analysis as to why the use of OR is so bad and to do a little performance testing, here's code to build...
--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 27, 2023 at 3:05 pm

#4246050

Viewing 15 posts - 1,261 through 1,275 (of 59,082 total)