Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 59,087 total)

Reply To: Do You Still Use CHAR?

below86 wrote:
Jeffrey Williams wrote:
below86 wrote:
I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes...
--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 14, 2022 at 6:04 pm

#3983520
Reply To: Yearly Uptime of Four Nines

Heh... plenty of time each week to do index maintenance, right? 😀 😀 😀
After almost 25 years, I wish MS would finally study Peter Norton's works and write something much...
--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 14, 2022 at 5:50 pm

#3983489
Reply To: Do You Still Use CHAR?

@rick,
I remember those days but that's actually a really bad example for system of today. Anyone that actually stores dates as a CHAR() in their normal database tables needs to...
--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 13, 2022 at 5:19 pm

#3983061
Reply To: Do You Still Use CHAR?

Rick, please tell me that you're not advocating a "panacea length" for VARCHAR(N) where "N" is something like 256. Please tell me you're not advocating the NUMERIC(18,N) should be 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)

February 13, 2022 at 1:39 am

#3982911
Reply To: Do You Still Use CHAR?

Robin Wilson wrote:
A popular college MIS system uses CHAR for many fields and this often leads to issues, not in the software, as that is built to account for this. However...
--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 13, 2022 at 1:36 am

#3982910
Reply To: Do You Still Use CHAR?

Johan Bijnens wrote:
Spot on, Jeff !
The main point for people to prefer varchar over char is that their GUI development tool doesn't have to bother with trailing spaces.
Lordy. I understand 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)

February 12, 2022 at 6:09 pm

#3982830
Reply To: Breaking Change - Feb 9, 2022

Um... ok. I'm confused. I thought you just said that SPAM is a bit of a problem.
Steve Jones - SSC Editor wrote:
.... but with the growth of SPAM items, it's a hassle.
Steve Jones - SSC Editor wrote:
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)

February 11, 2022 at 8:47 pm

#3982582
Reply To: Do You Still Use CHAR?

skeleton567 wrote:
Have any of you realized that the four-digit year is only good for another 7977 years? Better get ready.
I hope you and I are around to argue about 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)

February 11, 2022 at 6:55 pm

#3982546
Reply To: Breaking Change - Feb 9, 2022

Well that's cool! I even like how the site says "Not another MySQL install).
Understood on the spam. The cool part there is, if SPAM shows up on a thread 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)

February 11, 2022 at 4:17 pm

#3982499
Reply To: Restore Verify only failing.

Just curious... not including the path of the file, what is the name and extension of the file? The reason I ask is it sounds like they didn't send 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 11, 2022 at 3:32 pm

#3981934
Reply To: Do You Still Use CHAR?

skeleton567 wrote:
Jeff Moden wrote:
Caruncles wrote:
CHAR has bitten me numerous times...
How so? Especially when it comes to single byte stuff that even you know will never change?
I'd' say it's time to stop...
--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 11, 2022 at 3:17 pm

#3981932
Reply To: Do You Still Use CHAR?

skeleton567 wrote:
Just got a good laugh at the end of this conversation. Saw the following line. Is this a limitation of a CHAR data element?
Viewing 11 posts - 1 through...
--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 11, 2022 at 3:12 pm

#3981931
Reply To: Do You Still Use CHAR?

Caruncles wrote:
CHAR has bitten me numerous times...
How so? Especially when it comes to single byte stuff that even you know will never change?
--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 11, 2022 at 3:04 pm

#3981926
Reply To: Show only once repeated value in result a set

I almost always agree with Phil and Grant that this should be done at presentation time in whatever app is generating the final output.
But, then there's the human factors 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 11, 2022 at 3:01 pm

#3981922
Reply To: Do You Still Use CHAR?

This conversation brings up an ancient pain of mine and that's the mantra of "Pre-optimization is the root of all evil" parable that Knuth first stated in one of his...
--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 11, 2022 at 2:34 pm

#3981915

Viewing 15 posts - 3,916 through 3,930 (of 59,087 total)