Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 59,089 total)

Reply To: Useless Hackathons

ZZartin wrote:
Jeff Moden wrote:
Doctor Who 2 wrote:
Jeff Moden wrote:
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...
--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 16, 2021 at 6:01 pm

#3897100
Reply To: Useless Hackathons

Doctor Who 2 wrote:
ZZartin wrote:
I have a general issue with the idea that innovation comes from sitting people down cracking a whip and asking them to innovate. Maybe some people can work...
--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 16, 2021 at 5:22 pm

#3897075
Reply To: Useless Hackathons

Doctor Who 2 wrote:
Jeff Moden wrote:
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...
--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 16, 2021 at 5:03 pm

#3897070
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Jeffrey Williams wrote:
Thomas Franz wrote:
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if 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)

June 16, 2021 at 4:55 pm

#3897065
Reply To: EightKB... I'm presenting! Bring your water-cooled helmet! :D

Thanks, Johan. It's been a decade since the two of us have had the chance to talk in person. IIRC, the last time was at the PASS Summit of 2011.
--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 16, 2021 at 3:28 pm

#3897029
Reply To: Load folder full of csv files

Bruin wrote:
Can you send a more full blown version, and how I get(download) dbatools. I went to the page but didn't see how to download.
Many thanks!!!!
You mean you haven't actually...
--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 16, 2021 at 3:24 pm

#3897028
Reply To: How much will it cost or save to rebuild that index? (SQL Oolie)

Thomas Franz wrote:
Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it 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)

June 16, 2021 at 3:15 pm

#3897027
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

Viewing 15 posts - 5,131 through 5,145 (of 59,089 total)