Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,321 through 7,335 (of 59,072 total)

Reply To: Saving integers as varchar so that I can choose '' (empty) as content

christoph.kauflin wrote:
If I chose to save the employee number as a varchar, I could store '' (empty), which I would prefer.
frederico_fonseca wrote:
DON'T do it is the correct answer. All columns...
--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)

April 9, 2020 at 4:07 am

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

Grant Fritchey wrote:
Steve Jones - SSC Editor wrote:
Michael L John wrote:
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k 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)

April 9, 2020 at 4:02 am

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

Steve Jones - SSC Editor wrote:
It's interesting. A friend was over last night. He has 400+ reports under him. Had to let 10% go at the beginning of the year. Easy to do. Got...
--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)

April 9, 2020 at 4:00 am

#3741653
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

jcelko212 32090 wrote:
>> Employee numbers are not numbers!
Heh... I'll go ahead and disagree with you again, Joe. There's no reason why "identifiers" cannot be numbers.
--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)

April 9, 2020 at 3:54 am

#3741652
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Jonathan AC Roberts wrote:
Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2 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)

April 9, 2020 at 3:50 am

#3741651
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Ken McKelvey wrote:
Sorry for my blanket statement about NULLs - EndDate and Payment are good examples of when not to use them.
I am afraid I disagree with you about codes. Sooner...
--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)

April 9, 2020 at 3:44 am

#3741650
Reply To: Iterating Over Calculated Tables using Power Query

Ok... I got cricket's on that question... Here's what I'm talking about...
In the article, it first shows Step 1 as a T-SQL query to get the data "into" the Power...
--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)

April 9, 2020 at 1:20 am

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

Michael L John wrote:
Well, the big company meeting announcing what changes will be made was held this morning. I will still have a job, but everyone making over 60k is getting 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)

April 8, 2020 at 6:30 pm

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

Brandie Tarvin wrote:
Wow. My joke really hit with a thud. I'm surprised no one pulled out the Pork Chop Launcher on me. @=)
Nah... I was too busy laughing with you 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)

April 8, 2020 at 6:27 pm

#3741542
Reply To: Developer Edition

Grant Fritchey wrote:
Admingod wrote:
Sensitive data should absolutely not be in use in dev & test servers that means the data needs to me masked in dev?
Yes!
General Data Protection Regulation, California Citizens...
--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)

April 8, 2020 at 6:22 pm

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

No need to pile on for the following but, because of things like this, security breeches in the world just don't surprise me anymore.
https://www.sqlservercentral.com/forums/topic/only-one-expression-can-be-specified-in-the-select-list-when-the-subquery-is-not
How do these people get their...
--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)

April 8, 2020 at 5:21 pm

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

jasona.work wrote:
So, how's everyone surviving the shut in?
We've got a nice day on tap here, and while I'm putting in a couple extra hours this afternoon, I think I still...
--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)

April 8, 2020 at 5:18 pm

#3741519
Reply To: Arithmetic overflow error converting expression to data type nvarchar.

I think you also find that the Date data coming from an AS400 or IBM PowerSystem will contain all 0's for "null" dates.
Also, don't use VARCHAR(10) to hold string representations...
--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)

April 8, 2020 at 4:56 pm

#3741498
Reply To: Saving integers as varchar so that I can choose '' (empty) as content

Ken McKelvey wrote:
It is best to store integers as integers, dates as dates etc. There is nothing wrong with having nulls.
While I totally agree with the first statement there, I seriously...
--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)

April 8, 2020 at 4:42 pm

#3741496
Reply To: Compression: should I compress the entire table or each index indivitually?

reka_liebe wrote:
Before answering your question, first you need to priorities why you need compression. If the answer is you need to save space, then you will benefit from index compression....
--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)

April 8, 2020 at 3:49 pm

#3741474

Viewing 15 posts - 7,321 through 7,335 (of 59,072 total)