Jeff Moden

Forum Replies Created

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

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

Student031 - Monday, February 19, 2018 3:13 PM
Jeff Moden - Monday, February 19, 2018 2:23 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:37 am

#2017340
RE: Total count in Paging Query taking more time

My recommendation is to stop doing paging the old way. You've posted in a 2012 forum. Learn how to use the OFFSET/FETCH methodology of the ORDER BY clause. Please see...
--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:25 am

#2017339
RE: Best Practice for batch processing In SQL Server

Miru Seshadri - Wednesday, December 26, 2018 5:50 AM
Thank you Jeff. I will try that.
What is the difference between Xact Abort 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 26, 2018 at 9:13 am

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

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