Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,011 through 8,025 (of 59,072 total)

Reply To: SQL Newbie Help

If you're absolutely positive that 90 days will always be the magic number, you could make a computed column that would auto-magically populate the column for 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)

December 29, 2019 at 8:45 pm

#3711027
Reply To: Importing a CSV files in SSMS

How in SSMS is he importing the data? BULK INSERT or something from the menu?
--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 29, 2019 at 8:42 pm

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

Oh no... not to worry. I got "the jest" of it. 😀 That's why the smiley faces.
--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 29, 2019 at 8:39 pm

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

David Burrows wrote:
You said cursor, wash your mouth out and say three Hail Marys to repent :-/
😀 😀 😀
Agreed. Unless the list of stored procedures was in flux and needed 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 29, 2019 at 5:16 pm

#3711012
Reply To: TempDB won't shrink

What is the exact command that you're using to do the shrink?
How many files is TempDB made up 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)

December 28, 2019 at 9:09 pm

#3710964
Reply To: T-SQL Query Help

For those interested in what "Nominal Scale" actually is, there's a quick tutorial from 1:46 to 3:30 in the following video. The two examples that they use to explain 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)

December 28, 2019 at 7:43 pm

#3710950
Reply To: T-SQL Query Help

jcelko212 32090 wrote:
I'm assuming that an invoice number uses a nominal scale. This is not a magnitude or quantity. That means it has to be a character string, but perhaps we could...
--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 28, 2019 at 7:38 pm

#3710949
Reply To: Temporal Table Columns

DesNorton wrote:
I suppose that if you don't want the LOB data in the temporal table, you could move all LOB data to an extension table with the same PK as...
--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 28, 2019 at 4:25 pm

#3710940
Reply To: Temporal Table Columns

ScottPletcher wrote:
For (1), you could add a column to the table itself to store the original login name there too (or, far better to save space, an id (that 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)

December 28, 2019 at 4:14 pm

#3710939
Reply To: Temporal Table Columns

ScottPletcher wrote:
Jeff Moden wrote:
2. ... Current trigger technology won't even directly allow the saving of LOB columns because the LOB values don't show up in the INSERTED/DELETED logical tables in standard...
--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:37 pm

#3710833
Reply To: Test Topic for Blocked User

Apparently, not. 😉
--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:17 pm

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

Viewing 15 posts - 8,011 through 8,025 (of 59,072 total)