Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,116 through 5,130 (of 59,072 total)

Reply To: How to break zipcodes fileds with leading zeros

asita wrote:
I would like to see if any other alternatives were there. other than Case.. Please
Thank you
Heh... more likely, it's probably an interview question. 😉 It's a good one, IMHO,...
--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)

June 15, 2021 at 4:52 pm

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

Steve Jones - SSC Editor wrote:
FWIW, the 8KB schedule is online: https://eightkb.online/
Mr. Moden presenting, if you can make it, at Level 8192. Well above the 400-500 level of other sessions.
Heh... that level 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)

June 15, 2021 at 4:13 pm

#3896560
Reply To: Useless Hackathons

My basic trouble with hackathons in a company is... why do they actually need one to begin with? It seems like that's an admission that they don't embrace innovation during...
--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)

June 15, 2021 at 3:16 pm

#3896528
Reply To: Help with writing SQL logic

vaibhavktiwari wrote:
P.S. I am not sure what do you mean by "no directly usable data to test"
He means "Readily Consumable" data. Please see the article at the first link below...
--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)

June 15, 2021 at 1:37 pm

#3896489
Reply To: Load folder full of csv files

Yes, you would need to download and install the ACE drivers. If you use the quiet mode, you can do it without have to make the mistaken of uninstalling all...
--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)

June 15, 2021 at 1:33 pm

#3896487
Reply To: Load folder full of csv files

Bruin wrote:
That was a super fast load process... Just wanted to thanks again ... very impressive and well documented SP
Just a side question, what process do you choose to load...
--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)

June 15, 2021 at 2:37 am

#3896265
Reply To: can i enhance this query to run fast on sql server 2012 ?

Your code has an rCTE(Recursive CTE) in it that is reading 1 row at a time for a total of 21.45 million rows probably due to the result of an...
--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)

June 15, 2021 at 2:02 am

#3896250
Reply To: Live On Stage AND On Your Screen

I have to admit that I miss in-person events because, as good as they can be, discussions even on things like teams still don't have the "feel" and "serendipity" 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)

June 14, 2021 at 8:04 pm

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

Ed Wagner wrote:
Jeff Moden wrote:
That might also be the reason why they've done the RBAR thing in the trigger. They don't want to have everything during and Insert or Update roll back...
--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)

June 14, 2021 at 7:54 pm

#3896155
Reply To: what condition case when related to portion key mean ?

Jeffrey Williams wrote:
Jeff Moden wrote:
As it's written, it returns either a NULL or and empty string. I think someone forgot to complete the 2nd operand of the substring, which should probably equate...
--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)

June 14, 2021 at 7:37 pm

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

That might also be the reason why they've done the RBAR thing in the trigger. They don't want to have everything during and Insert or Update roll back if something...
--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)

June 14, 2021 at 7:19 pm

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

I would think that a trigger to try to catch errors in other places would be mostly useless for a lot of code but I don't see anything wrong with...
--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)

June 14, 2021 at 7:15 pm

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

Brandie Tarvin wrote:
I just took a glance at the trigger. The size of the thing is truly horrendous.
If it's for a table with a large number of columns and it's an...
--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)

June 14, 2021 at 2:39 pm

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

Brandie Tarvin wrote:
Brief tangent into real SQL stuff...
Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?
Our vendor sent us code for...
--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)

June 14, 2021 at 1:18 pm

#3895953
Reply To: Load folder full of csv files

Ok. Mostly done. We still need to add some "pretty" error handling and the file move-after-imported thing but this is working quite nicely and it does tolerate errors along with...
--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)

June 14, 2021 at 6:08 am

#3895803

Viewing 15 posts - 5,116 through 5,130 (of 59,072 total)