Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,101 through 5,115 (of 59,072 total)

Reply To: Does Every BEGIN require an END

You claim to have 3rd party software that demonstrates that. Why do we need to provide an example? I've never seen such a thing but could be wrong. Post 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)

June 17, 2021 at 8:18 pm

#3897713
Reply To: How to break zipcodes fileds with leading zeros

Jeffrey Williams wrote:
ScottPletcher wrote:
According to your sample data and results, the "Answer" you marked is not correct. For example, you stated that '10000' should return a 1 -- "Anything between 00000...
--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 17, 2021 at 8:09 pm

#3897709
Reply To: How to break zipcodes fileds with leading zeros

Jeffrey Williams wrote:
ScottPletcher wrote:
Why? If what you're saying is true, then just use the first char in the value as the category, that's less overhead than any kind of table lookup.
Because...
--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 17, 2021 at 8:07 pm

#3897708
Reply To: Handling reports of slow-running procedures

I've found that it's not often a "slow running query" is the actual problem. I've found that it's normally one that could certainly run better/faster/fewer-resources that runs hundreds or thousands...
--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 17, 2021 at 8:05 pm

#3897707
Reply To: table script to dump to csv with foreign key order

p.s. I also wouldn't use the "data" feature of the above method because it creates and INSERT/VALUEs statement for every bloody row of data.
If you use a product like RedGate...
--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 17, 2021 at 7:56 pm

#3897706
Reply To: table script to dump to csv with foreign key order

If you only need to do this occasionally, it might just be simpler to open the Object Explorer window in SSMS (press the {f8} key to open it if it's...
--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 17, 2021 at 7:54 pm

#3897705
Reply To: How to break zipcodes fileds with leading zeros

asita wrote:
Thank you for your inputs I apologize for my mistake in my sample the last case statement is 9. not 0.
Thank you for all your assistance and guidance
Ok... 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)

June 17, 2021 at 5:44 pm

#3897603
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 17, 2021 at 5:03 pm

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

Viewing 15 posts - 5,101 through 5,115 (of 59,072 total)