Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 59,091 total)

Reply To: T-SQL Query Help

wrote:
(invoice_nbr CHAR(4) NOT NULL,
Good lord, NO! That is so wrong in so many ways! I suggest you read any good book on RDBMSs, especially if your going 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)

December 27, 2019 at 6:13 pm

#3710822
Reply To: Working with variable length number

jcelko212 32090 wrote:
You're trying to fix it on the fly in your code and it doesn't really work that way in the real world.
Absolutely agreed but, unfortunately, the real world 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)

December 27, 2019 at 6:05 pm

#3710817
Reply To: Meaning of WHERE x NOT LIKE '% %'

RichardFRay wrote:
“Security through obscurity.”
Yep, that’s me. At the longest it’s been another 2”, but i live in Jackson, Wyoming and the beard can collect inconvenient amounts of ice sometimes.
I live...
--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)

December 27, 2019 at 5:59 pm

#3710816
Reply To: Meaning of WHERE x NOT LIKE '% %'

jcelko212 32090 wrote:
ISO standards forbid embedded spaces in the encodings. There's also a set of Unicode characters that have to be used. It's the digits, Latin letters, and a limited set...
--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)

December 27, 2019 at 5:56 pm

#3710815
Reply To: T-SQL Query Help

I also suspect that you want this to be conditional to check if there already is a "First Try" or not and add the extra row if there isn't. I...
--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)

December 27, 2019 at 4:32 pm

#3710786
Reply To: importing text file, bulk insert to populate table

Jeff Moden wrote:
@smattiko83,
Do you also want the dates to be validated as "real" dates?
I'm asking this question because the translations you ask for are fairly trivial and I'm trying to generate...
--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)

December 27, 2019 at 4:23 pm

#3710784
Reply To: how to increase batch size to 100000

If you're generating individual INSERT/VALUES statements, I wouldn't do that because it will take a month of Sundays to complete 1 million rows. In fact, most methods will not 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)

December 27, 2019 at 4:18 pm

#3710783
Reply To: how to force a procedure to execute the first ?

If order of execution is important for 1 procedure, it's likely inevitable that order of execution will be come a necessity for others, as well. My recommendation is to build...
--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)

December 27, 2019 at 4:02 pm

#3710780
Reply To: The Best DBA Gifts

As to the question of what I'd like from work, the answer is for things to NOT change. I'm one of the fortunate few in the world when it comes...
--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)

December 27, 2019 at 3:47 pm

#3710778
Reply To: The Best DBA Gifts

skeleton567 wrote:
My best gift is another year with my wife of 40 years whom twice doctors gave up for lost, but who has survived and overcome bilateral below-knee amputation 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)

December 27, 2019 at 3:40 pm

#3710776
Reply To: Meaning of WHERE x NOT LIKE '% %'

Unfortunately, I've seen that and more. I've even seen people add trailing spaces to all of their object names to make it more difficult to use what they've built. Crazy...
--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)

December 27, 2019 at 3:34 pm

#3710774
Reply To: Why columnstore indexes are not very popular?

Sergiy wrote:
I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages of splitting datetime into date and time.
That's very true. And, sorry...
--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)

December 27, 2019 at 3:27 pm

#3710769
Reply To: Why columnstore indexes are not very popular?

Grant Fritchey wrote:
Sergiy wrote:
Frederico, do you have any test case to support your speculations?
I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages...
--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)

December 27, 2019 at 3:23 pm

#3710767
Reply To: Meaning of WHERE x NOT LIKE '% %'

I've not executed the code but it looks to me like they're trying to reject rows where the name has any spaces.
--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)

December 27, 2019 at 12:03 am

#3710621
Reply To: importing text file, bulk insert to populate table

@smattiko83,
Do you also want the dates to be validated as "real" dates?
--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)

December 26, 2019 at 11:57 pm

#3710620

Viewing 15 posts - 8,041 through 8,055 (of 59,091 total)