Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,246 through 10,260 (of 59,099 total)

RE: How to implement taking action based in column value?

inshah2297 - Wednesday, December 26, 2018 4:17 AM
RBAR is articulated ree-bar and is a Modenism for Line By-Anguishing Column. Initial move towards...
--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, 2018 at 9:10 am

#2017335
RE: Changing Datatype from Int to TinyInt - How much space can be recovered?

Mahesh Bote - Wednesday, December 26, 2018 12:48 AM
Jeff Moden - Tuesday, December 25, 2018 4:07 PM
--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, 2018 at 9:05 am

#2017334
RE: Christmas DevOps

Eric M Russell - Wednesday, December 26, 2018 7:33 AM
Hey, the days leading up to Christmas is the perfect time for team...
--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, 2018 at 7:47 am

#2017323
RE: Changing Datatype from Int to TinyInt - How much space can be recovered?

Lynn Pettis - Tuesday, December 25, 2018 12:10 PM
Mahesh Bote - Tuesday, December 25, 2018 8:09 AM
--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 25, 2018 at 4:07 pm

#2017304
RE: Parent/Child - where I am standing

jcelko212 32090 - Tuesday, December 25, 2018 3:29 PM
It got strange at times. The kids could not conceptually separate a number, 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 25, 2018 at 3:49 pm

#2017303
RE: Christmas DevOps

'Twas the night before Christmas and all through "The Room",
The servers were humming and no apps have gone "Boom'
This is all possible because we worked as a Team,
And...
--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 24, 2018 at 8:57 pm

#2017295
RE: Are the posted questions getting worse?

'Twas the night before Christmas and all through "The Room",
The servers were humming and no apps have gone "Boom'
This is all possible because we worked as a Team,
And...
--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 24, 2018 at 8:56 pm

#2017294
RE: Sample TSQL , SSIS , SSRS projects

daniarchitect - Monday, December 24, 2018 11:16 AM
Thom A - Monday, December 24, 2018 8:07 AM
--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 24, 2018 at 4:54 pm

#2017292
RE: Parent/Child - where I am standing

shamshad.ali - Monday, December 24, 2018 4:31 AM
In parent child, I want to pass EmployeeId and get the list of all parents...
--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 24, 2018 at 3:37 pm

#2017291
RE: Parent/Child - where I am standing

jcelko212 32090 - Monday, December 24, 2018 11:04 AM
>> In parent-child, I want to pass emp_id and get the list of all...
--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 24, 2018 at 2:05 pm

#2017290
RE: Queries to practice compilation and recompilation.

Tac11 - Monday, December 24, 2018 10:04 AM
Yes, Jeff.
It's pretty easy to do such a thing. All you need to do 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 24, 2018 at 11:09 am

#2017281
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, December 24, 2018 8:08 AM
Merry Christmas and Happy Holidays. Everyone be safe and enjoy time...
--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 24, 2018 at 10:47 am

#2017237
RE: Validate date stored as a string as a complete, valid date

Scott In Sydney - Thursday, December 20, 2018 11:30 PM
ScottPletcher - Tuesday, December 18, 2018 11:12...
--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 24, 2018 at 10:41 am

#2017236
RE: Understanding Peer-to-Peer Transactional Replication, Part 1

samot-dwarf - Sunday, December 23, 2018 10:37 AM
I agree to the article beside the part about the clustering key and Fillfactor. The...
--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 23, 2018 at 9:34 pm

#2017178
RE: fetch multiple rows with single string

abhas - Sunday, December 23, 2018 5:03 AM
Hello friends,
I am having table which contains data stdentname,teachername,subjectname as below.
Studentname ...
--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 23, 2018 at 8:48 am

#2017169

Viewing 15 posts - 10,246 through 10,260 (of 59,099 total)