Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 59,082 total)

Reply To: Gentlest of Reminders, Don't Stop Learning

@Grant,
I love this article but I'd like to add a nuance to it, especially after what Rick and I were just "talking" about in some of the sayings we listed.
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)

September 23, 2023 at 8:50 pm

#4292720
Reply To: Gentlest of Reminders, Don't Stop Learning

skeleton567 wrote:
Jeff Moden wrote:
Heh... totally agreed. It matches one of the mantra's that I carry in my signature line below...
"Change is inevitable... Change for the better is not."
And I'll add 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)

September 23, 2023 at 8:06 pm

#4292696
Reply To: Get data from wmic/winmgmt/etc

us26 wrote:
Thanks for your solution! Looks awesome. The only one disadvantage is necessity to give names to columns manually. Is there any way to do it automatically? Preferably without dynamic-sql.
[quote-0...
Attachments:
You must be logged in to view attached files.
--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 23, 2023 at 7:35 pm

#4292687
Reply To: Gentlest of Reminders, Don't Stop Learning

gregg_dn wrote:
I don't mind changes to software etc. that actually improve the product, but so many changes these days seem to occur just to give the developers something 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)

September 23, 2023 at 7:23 pm

#4292686
Reply To: Partition Large Tables needed

sqlguy80 wrote:
Thanks for the message,
What are the disadvantages of partitioning? does it need manual management?
Can we fix those issues which partitioning addresses using other solutions?
I've personally found that partitioned tables...
--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 23, 2023 at 1:20 am

#4292250
Reply To: Query goes crazy.

I have no real idea except to say that yours isn't the first post where On-prem performance blew the doors off of cloud performance in similar tests. You might want...
--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 23, 2023 at 12:49 am

#4292225
Reply To: Query goes crazy.

Have you looked to see if the indexes on the table are the same? Have you updated statistics lately on 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)

September 23, 2023 at 12:22 am

#4292194
Reply To: Weekly sales report

Heh... apparently, the OP has left the building. 😀
--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 22, 2023 at 10:47 pm

#4292156
Reply To: table with varcahar(max)

IMHO, take the time to force the MAX to be out of row and default the error to an empty string to prevent the pointer from being "expansive". Have max...
--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 22, 2023 at 10:45 pm

#4292155
Reply To: Weekly sales report

pietlinden wrote:
If you're going to do lots of date-related analysis, I'd just create a Calendar table with all the columns you want to group by, and then join to 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)

September 22, 2023 at 4:23 pm

#4291976
Reply To: calculate and decimal

tanehome wrote:
yes, it works.
appreciate your reply.
The question now is, do you understand why the fix worked and why you were getting the original issue?
The other question is, do you know...
--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 21, 2023 at 9:54 pm

#4291331
Reply To: Best CI/CD or release process

Bumping this for you because I'd like to see what other people have to say about this for Database 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 21, 2023 at 9:52 pm

#4291330
Reply To: Transaction log full due to LOG_BACKUP

On the subject of the backup failure...
IMHO (and experience but YMMV), it's a complete waste of time to backup a 2TB log file (happened to me the 2nd day of...
--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 21, 2023 at 9:43 pm

#4291329
Reply To: Weekly sales report

Next year, the 1st of January occurs on a Monday. What do you want to do with the previous Sunday, which is from the previous year?
--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 21, 2023 at 9:34 pm

#4291328
Reply To: Transaction log full due to LOG_BACKUP

Sorry... posted to the wrong question and removed this post. See the next post down for my answer on this posted problem.
--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 21, 2023 at 9:33 pm

#4291327

Viewing 15 posts - 1,096 through 1,110 (of 59,082 total)

Jeff Moden

Forum Replies Created

Attachments: