Jeff Moden

Forum Replies Created

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

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
RE: Partitioning Data on First Character

alex.sqldba - Wednesday, September 20, 2017 3:53 AM
I am partitioning for two reasons:
firstly so that entire partitions can be phased out, that...
--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 9:54 am

#1960196
RE: Recursive CTE help

Ray K - Wednesday, September 20, 2017 9:34 AM
Well, the example data I posted pretty much is the input, starting with 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)

September 20, 2017 at 9:50 am

#1960195
RE: Interviews: What is ACID?

Steve Jones - SSC Editor - Wednesday, September 20, 2017 8:53 AM
Jeff Moden - Tuesday, September 19,...
--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 9:46 am

#1960193
RE: Interviews: What is ACID?

Matt Miller (4) - Wednesday, September 20, 2017 9:20 AM
Whatever you do - just don't ask jeff how to clear a table...
--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 9:45 am

#1960191

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