Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,266 through 14,280 (of 59,101 total)

RE: Are the posted questions getting worse?

crow1969 - Thursday, September 21, 2017 9:34 AM
I would guess the conversion routine simply drops all thousands separators, and then converts 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)

September 21, 2017 at 11:42 pm

#1960435
RE: Mortgage amortization table

Jason A. Long - Wednesday, September 20, 2017 9:43 PM
You don't pay interest on interest ever. Unpaid interest and principal balance are...
--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)

September 21, 2017 at 7:10 am

#1960357
RE: General interview questions

Check out the following...
https://www.youtube.com/watch?v=XKu_SEDAykw
I'm not a C# programmer but my personal feeling is that both the interviewer and the interviewee failed massively. For example, both talked 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)

September 20, 2017 at 10:27 pm

#1960305
RE: Challenge: Insert a specific number of rows based on an integer column in one query!

Jasmine D. Adamson - Wednesday, September 20, 2017 6:03 PM
Thanks Jeff, those are very helpful! I like that way of describing what'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)

September 20, 2017 at 8:43 pm

#1960301
RE: Column Arrangement

jcelko212 32090 - Wednesday, September 20, 2017 2:51 PM
Did you know that identifiers can never be numeric because you donâ€™t do any...
--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)

September 20, 2017 at 7:35 pm

#1960297
RE: Voting for Change

allinadazework - Friday, September 15, 2017 1:36 AM
I dutifully tried to upvote the "string or binary data truncated" on the link 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)

September 20, 2017 at 7:17 pm

#1960296
RE: Challenge: Insert a specific number of rows based on an integer column in one query!

It won't matter much for performance for your function because it calls a slow but required scalar function but, after 20 years of doing this, it's time to learn how...
--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)

September 20, 2017 at 5:57 pm

#1960293
RE: Challenge: Insert a specific number of rows based on an integer column in one query!

Jasmine D. Adamson - Wednesday, September 20, 2017 2:53 PM
Oh I see now! I'm going to have to spend the rest 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)

September 20, 2017 at 5:23 pm

#1960292
RE: How to encrypt Credit Card numbers?

Jack Corbett - Friday, September 8, 2017 12:38 PM
My recommendation is always to have the application handle encryption and decryption....
--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)

September 20, 2017 at 2:25 pm

#1960271
RE: Interviews: What is ACID?

jasona.work - Wednesday, September 20, 2017 11:16 AM
Steve Jones - SSC Editor - Wednesday, September 20, 2017...
--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)

September 20, 2017 at 2:18 pm

#1960268
RE: Interviews: What is ACID?

Eric M Russell - Wednesday, September 20, 2017 12:07 PM
I would never ask a question like "What is a clustered index?" or...
--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)

September 20, 2017 at 2:17 pm

#1960267
RE: Partitioning Data on First Character

alex.sqldba - Wednesday, September 20, 2017 10:30 AM
No. That character is static and stable.
Ultimately it is 1 character per year and we're...
--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)

September 20, 2017 at 11:05 am

#1960215
RE: HIERARCHYID DataType and Referential Integrity

kramaswamy - Wednesday, September 20, 2017 10:11 AM
Thanks Jeff - I'll take a look at your suggestions.
But as to my original question, 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)

September 20, 2017 at 11:02 am

#1960212
RE: Setup the sync process against Large Database

Any feedback on the code I posted?
--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)

September 20, 2017 at 10:28 am

#1960204
RE: view time out

tomashons - Tuesday, September 19, 2017 9:55 AM
Hello there is solution:
Run -> regedit -> Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0(or 14.0 depends on...
--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)

September 20, 2017 at 10:26 am

#1960202

Viewing 15 posts - 14,266 through 14,280 (of 59,101 total)