Jeff Moden

Forum Replies Created

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

Reply To: Delaying the code

BWAAAA-HAAAA-HAAAA!!!! I'm thinking that this question is the result of someone learning something the hard way! 😀 😀 😀
Great "gotcha" question, Steve!
--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)

January 2, 2020 at 4:10 pm

#3711835
Reply To: Exporting Data with PowerShell

This is a great introduction to exporting files with PoSh, Steve. I gave it a 5. That and the mention of how to do it with DBATools is great. 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)

January 2, 2020 at 3:46 pm

#3711826
Reply To: How to calculate income tax for a slab based taxation system?
If you add just one more column to the table, you can avoid the Triangular Joins that are created to calculate things that will not change for a given year. ...
- This reply was modified 6 years, 9 months ago by Jeff Moden. Reason: Double up on the single quotes so that the awful forum software doesn't make it all look like dynamic SQL (and none of 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)
January 1, 2020 at 11:53 pm

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

Lynn Pettis wrote:
Happy New Year to all.
Same back at ya, Lynn.
--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)

January 1, 2020 at 11:15 pm

#3711656
Reply To: Data Migration to S/4 Hana

frederico_fonseca wrote:
really annoys me when people don't even bother searching for what they need.
hana studio and Hana client are required - you get those from SAP
first link google returned https://blogs.sap.com/2016/08/05/how-to-connect-microsoft-ssis-with-sap-hana/
yes...
--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)

January 1, 2020 at 11:06 pm

#3711654
Reply To: T-SQL Query Help

jcelko212 32090 wrote:
>> Joe, do you convert back to numeric to get your next successive order number and then convert back to character data? With all the back and forth about...
--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)

January 1, 2020 at 10:57 pm

#3711651
Reply To: Date Dimension

My personal opinion is that people put entirely too much into Calender/DateDim tables. An example of this is people that store the full name of the days of the week,...
--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)

January 1, 2020 at 4:21 pm

#3711633
Reply To: Data Migration to S/4 Hana

With the disclaimer that this is the first I've ever even heard of {SAP} S/4 Hana databases...
I assume that, since you're posting on an SQL Server forum and mentioned SSIS, ...
--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)

January 1, 2020 at 3:24 pm

#3711619
Reply To: TempDB won't shrink

DBCC SHRINKFILE on its own isn't the full command... especially if you have 8 files in total. I'm thinking that you need 8 separate commands for that along with 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)

December 31, 2019 at 10:42 pm

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

Steve Jones - SSC Editor wrote:
Not me, back at work and getting some things done here today.
Enjoy the holiday, and be safe. My daughter had surgery last week, so we're still helping her recover...
--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 31, 2019 at 10:36 pm

#3711557
Reply To: Importing a CSV files in SSMS

itmasterw 60042 wrote:
Yes, but more to the point I wanted to know if what I proposed would import the data without the line feed?
Or how can I do that?
Thank you
Like 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 31, 2019 at 4:44 am

#3711368
Reply To: Temporal Table Columns

Bah! It's just not worth it. You can't add a default column to Temporal Tables. You can't add a column to the History table without adding it to the main...
--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 31, 2019 at 4:39 am

#3711367
Reply To: Temporal Table Columns

Crud. I was afraid of that. The dynamic SQL cannot see the INSERTED/DELETED tables, either. I could copy the INSERTED table to a temporary table or table variable but that'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)

December 31, 2019 at 2:26 am

#3711365
Reply To: Temporal Table Columns

p.s. I wish they'd fix the bloody code windows for color on SSC. It would be better if they simply rendered out as all black rather than serious color mistakes...
--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 31, 2019 at 1:51 am

#3711362
Reply To: Temporal Table Columns

That works great but only if that's the only UPDATE trigger on the table. Here's a test that shows that even though the value of some columns hasn't been changed,...
--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 31, 2019 at 1:49 am

#3711361

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