Jeff Moden

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 59,063 total)

Reply To: Don't Create Workslop

My biggest concern is people using it to do the things they don't know anything about.
A couple of recent examples that I've come up with are to ask AI 1)...
--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)

November 17, 2025 at 5:31 am

#4686360
Reply To: Deleting data in large table

As for the old table, you were going to delete all but a million rows. When you're sure the copy worked correctly, just drop the old table.
Also, decide the maximum...
--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)

November 1, 2025 at 7:52 pm

#4679995
Reply To: Deleting data in large table

Jackie Lowery wrote:
I also read about using 'SWITCH' to map the data to the backup table, then insert the records back into the original table. Once the data dump is done,...
--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)

November 1, 2025 at 7:45 pm

#4679994
Reply To: Deleting data in large table

If you're going to remove 25% or more of the data from a HEAP or a Table (Clustered Index Present), the best thing to do all the way around 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)

November 1, 2025 at 6:32 pm

#4679977
Reply To: How to safely and surgically restore filegroups

Good article. Thanks for taking the time to write it up.
What I'd like to see is...
You have a database that has a partitioned table. The partitioned table has 1 filegroup...
--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)

November 1, 2025 at 6:06 pm

#4679976
Reply To: Line number in error message doesn't match up with line number in code

This is a classic problem with where to start counting. It's compounded by the fact that when people generate the code for modification, it frequently adds a blank line above...
--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)

October 26, 2025 at 11:12 pm

#4677931
Reply To: Practice Until You Don't Get It Wrong

Let me understand this clearly... an "intern" had the privs to bring a production database down?
Seriously???

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

October 26, 2025 at 7:29 pm

#4677894
Reply To: I Love Editorials

I think opinions are great for the same reasons as you, Grant. Just not when it comes to things like code. I've seen way too many things that turned out...
--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)

October 19, 2025 at 10:55 pm

#4674838
Reply To: Working with Synonym on Scalar Functions

glennthomas@flyingwood.com wrote:
Oz-860645 was happy to come here for a quick answer but then says "Nevermind, I figured it out." and disappeared.
When I created the synonym I did it without 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)

October 17, 2025 at 6:49 pm

#4673799
Reply To: Don't want to connect to the high transactional on-premises SQL Server Database

Sorry I'm lat on this thread and I may have missed it but no one is talking about the licensing costs of the SQL Server on the separate machine.
Also, 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)

October 17, 2025 at 5:38 pm

#4673774
Reply To: Who am I?

Thomas Franz wrote:
When you want it 100% correct, you should use ORIGINAL_LOGIN().
Especially when, IMHO, people use that nasty little word of "audit" like they did in this question.
--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)

October 7, 2025 at 1:40 am

#4666733
Reply To: is there a way to "detect" schema like changes on a server?

This can be done by creating database level triggers and can seriously be enhanced in capturing not only what changed when but by who from where.
I can't offer the code...
--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 17, 2025 at 5:30 am

#4653177
Reply To: how to optimise whole database full of table and sp in one go using githubcopilo

rajemessage 14195 wrote:
i have a database with 400 stored porcedure , i need to optimise it , i found that tables are not having command index also.
like joins where ,group by...
--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 15, 2025 at 8:14 pm

#4652363
Reply To: Tables with a SPARSE Column and Consumption

Great question. Proof that extra features always come at a price. 😀
It also means more page splits than normal due to "ExpAnsive" UPDATEs because of the typical extra 4 bytes...
--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 15, 2025 at 6:19 pm

#4652322
Reply To: Work out closing balance using opening balance of prior month

Steve Collins wrote:
Btw, I disagree with those who suggest to always specify the windowing range. The default is ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. Why repeat it? The best part...
--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 13, 2025 at 3:12 am

#4650967

Viewing 15 posts - 31 through 45 (of 59,063 total)