Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 59,067 total)

Reply To: Improving Skills at Work
Rod at work wrote:
Steve Jones - SSC Editor wrote:
FWIW, Jeff, it would be great to see a list of common SQL problems that people ought to be able to solve. I'd add in
- running totals
- deserializing...
--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 16, 2023 at 7:40 pm

#4150736
Reply To: Need to do a mass update - taking days

Ed B wrote:
Trust me, I don’t use format specifically because of your previous remarks. I changed as little as possible to illustrate a point.
Ah... now I understand. Heh... I thought "WTH? ...
--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 16, 2023 at 3:38 am

#4150354
Reply To: Need to do a mass update - taking days

krypto69 wrote:
Thanks Jeff!
Hey wait...So format not so great? Googling now...
Don't "Google It". Most people don't have a clue about it. Go read the article I provided the link for. 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 16, 2023 at 3:34 am

#4150353
Reply To: Dealing with super huge table which is partially partitioned.

Also, what would you folks partition the table on? The reason I ask that is that I DO have a partitioned table. It's only about 2TB with 10 years 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)

February 16, 2023 at 3:30 am

#4150352
Reply To: The Cost of the Cloud

Heh... Some of the people I've had to work with in the past seem to make a pretty good living at "If it ain't broke, fix it until is" mantra....
--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 16, 2023 at 3:05 am

#4150348
Reply To: Dealing with super huge table which is partially partitioned.

Crud... forum software lost my page on page 2... "bumping" that page with this post to get it to show up.

--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 16, 2023 at 2:52 am

#4150338
Reply To: Dealing with super huge table which is partially partitioned.

I'm curious... has anyone checked to see if any of that 17TB can be archived and moved out of the main table?
--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 16, 2023 at 2:49 am

#4150337
Reply To: Aggregate Select Results and convert Secs to Hours Mins.

@Wecks ...
Getting back to the subject and with the understanding that I try to anticipate the proverbial "next question" from my users, here's what I'd do along with some documentation...
--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 16, 2023 at 2:22 am

#4150334
Reply To: Aggregate Select Results and convert Secs to Hours Mins.

BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do. The technology behind all of that is mind boggling . My biggest...
--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 16, 2023 at 2:05 am

#4150332
Reply To: Need to do a mass update - taking days

Ok... I'm playing with a copy of the Person.Person table from a copy of the Adventure Works database. I created 3 "scratch" tables, one for each name column, and populated...
--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 16, 2023 at 1:33 am

#4150308
Reply To: Need to do a mass update - taking days

Jeffrey Williams wrote:
You can probably get a significant boost to performance by removing FORMAT and converting those JOINS to a single CROSS APPLY.
It appears you are looking up the anonymized user...
--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 16, 2023 at 1:23 am

#4150299
Reply To: Need to do a mass update - taking days

Heh... Ed... as Jeffrey Williams also recommended, my sincere and very friendly recommendation is that you stop using FORMAT. It's 17 times slower that just about any other rabbit 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)

February 16, 2023 at 1:15 am

#4150297
Reply To: Alternative to row_number in natively compiled stored procedure

You are at the edge of a cliff. I strongly recommend you turn around and go another way.
--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 15, 2023 at 9:37 pm

#4150263
Reply To: Aggregate Select Results and convert Secs to Hours Mins.

Heh... I did that with the count 1 to a million thing. IIRC, I posted that little gem that said the rCTE that it created (which I also told 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 15, 2023 at 9:02 pm

#4150259
Reply To: Aggregate Select Results and convert Secs to Hours Mins.

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Thanks for taking the time to do these experiments, Jonathan.
The reason it got the Zip right is because it's in quotes. You also had to realize its mistakes...
--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 15, 2023 at 8:56 pm

#4150245

Viewing 15 posts - 1,876 through 1,890 (of 59,067 total)