Jeff Moden

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 59,067 total)

Reply To: Found a Tool Very Helpful for Beginner

I appreciate your honest replies and your professionalism in wanting to help others as you learn. That's pretty much the spirit for most of the long term denizens of this...
--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)

February 26, 2025 at 11:39 pm

#4546852
Reply To: Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric

John Miner wrote:
I am curious how it (GENERATE_SERIES function)performs compared to the tally table.
It's nasty fast. It's not as flexible as you'll find in other flavors of SQL because it "only"...
--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)

February 26, 2025 at 8:50 pm

#4546767
Reply To: Unable to delete records from table

Ant-Green wrote:
That trigger was placed there for a reason.
In financing terms once something is on a journal / ledger, it should ALWAYS remain on that journal / ledger.
If there was...
--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)

February 26, 2025 at 5:27 pm

#4546634
Reply To: Why Not Use AI?

jasona.work wrote:
Largely speaking, I've thus far not used any of the various and sundry "AI" implementations out there (either for SQL or anything else,) mostly because, well, I don't see...
--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)

February 26, 2025 at 5:22 pm

#4546631
Reply To: Trust is a Funny Thing

David.Poole wrote:
Decades of change and experimentation just to find out that SQLServerCentral remains one of the best online forums.
The system won't let me give that comment the million or so...
--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)

February 26, 2025 at 2:27 am

#4546151
Reply To: Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric

Hi, John. Gosh... it's been a long time since we've seen each other in person.
Nice article and thank you for the honorable mention.
Just to add a bit of a clarification,...
--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)

February 26, 2025 at 2:20 am

#4546150
Reply To: Why Not Use AI?

The conversation about all of that seems like it started on LinkedIn. IIRC, they were announcing that CoPilot was coming out as a part of a new release of SSMS...
--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)

February 26, 2025 at 1:57 am

#4546135
Reply To: Found a Tool Very Helpful for Beginner
The post is fine and appropriate. It also introduces some of the meta-data available about tables and a couple of things.
I have a couple of questions for you, though....
1. It...
--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)
February 26, 2025 at 12:31 am

#4546107
Reply To: Backup taking too much time

If those backup drives are on the same system as your SQL Server, you need to move them to a different machine, ASAP.
Also, why are you using SQLCMD to 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)

February 26, 2025 at 12:08 am

#4546100
Reply To: How Do You Change Data Type from uniqueidentifier

Ahr Aitch wrote:
Thanks, Jeff.
I learned a good deal from your post. I did not know about the square brackets syntax requirement. I also learned more about using schema.
Thanks, again.
My pleasure 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)

February 25, 2025 at 10:35 pm

#4546040
Reply To: Index Fragmentation

Srinivas Merugu wrote:
Below script will use to get single table or multiple tables or all tables DB fragmentation details .
Hello and welcome aboard! I appreciate anyone that steps up to 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)

February 25, 2025 at 10:22 pm

#4546023
Reply To: Trust is a Funny Thing

From the article:
"Essentially one mistake overrides everything else."
We had a saying in the Navy... "One 'Aw Shit' wipes out a thousand 'Attaboys' ".
And, it doesn't matter if it's for 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)

February 24, 2025 at 4:19 am

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

Sean Lange wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
DesNorton wrote:
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn'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)

February 21, 2025 at 9:35 pm

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

DesNorton wrote:
Congratulations @jeff-moden Finally overtook the high priestess on the SSC overall leaderboard.
She did have a shedload of LIKEs. The "upgrade" on the site years ago hasn't helped much either. ...
--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)

February 19, 2025 at 8:43 pm

#4541531
Reply To: How Do You Change Data Type from uniqueidentifier

Ahr Aitch wrote:
In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that has a datatype of uniqueidentifier.
I assigned that value not knowing 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)

February 18, 2025 at 9:36 pm

#4540708

Viewing 15 posts - 136 through 150 (of 59,067 total)