Jeff Moden

Forum Replies Created

Viewing 15 posts - 151 through 165 (of 59,075 total)

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
Reply To: blocking folks from using a linked server and plumbing one to specific dsn

Here's the section of the documentation that seems to apply here and it's in the form of step-by-step instructions. I do NOT know for sure if this will prevent DBAs...
--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 17, 2025 at 1:12 am

#4539243
Reply To: Restore all Databases in a Directory

Hemantgiri S. Goswami wrote:
I had to modify the script (added a couple of columns in @FileList and @DbNameHeaders) and added some more logic to suit my needs.
This script works like charm in...
--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 17, 2025 at 1:02 am

#4539242

Viewing 15 posts - 151 through 165 (of 59,075 total)