Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,051 through 13,065 (of 59,099 total)

RE: SQL Server to recognize each individual user

jasona.work - Wednesday, January 24, 2018 1:45 PM
Vic,
Presuming your server is using Windows Authentication and your front end (which you indicated 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 24, 2018 at 2:39 pm

#1977214
RE: Is learning Python/R an advantage for SQL Server Developers? Need an expert advice.

GroverVivek - Wednesday, January 24, 2018 5:50 AM
Hello Guys,
Is it time for SQL Server Developers to start learning R/Python to excel in...
--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 24, 2018 at 12:51 pm

#1977185
RE: Should I add indexes to a log table?

Before you add any indexes, examine the code that's having the performance issue and make sure that the code is SARGable and will actually be able to make use 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)

January 24, 2018 at 12:48 pm

#1977184
RE: SQL Server to recognize each individual user

Vic Rauch-303403 - Wednesday, January 24, 2018 10:41 AM
What must I do within SQL Server or the SQL Database itself in order...
--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 24, 2018 at 11:48 am

#1977169
RE: Question Regarding Date logic

ScottPletcher - Wednesday, January 24, 2018 9:28 AM
Jeff Moden - Wednesday, January 24, 2018 9:21 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)

January 24, 2018 at 9:34 am

#1977137
RE: Effectiveness

Tom John-342103 - Wednesday, January 24, 2018 8:58 AM
Jeff Moden - Wednesday, January 24, 2018 8:34 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)

January 24, 2018 at 9:28 am

#1977133
RE: Question Regarding Date logic

ScottPletcher - Wednesday, January 24, 2018 9:01 AM
Lynn Pettis - Tuesday, January 23, 2018 4:10 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)

January 24, 2018 at 9:21 am

#1977130
RE: Delayed gratification or not?

MMartin1 - Tuesday, January 23, 2018 10:52 PM
Jeff Moden - Monday, December 11, 2017 6:25 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)

January 24, 2018 at 9:08 am

#1977126
RE: Question Regarding Date logic

below86 - Wednesday, January 24, 2018 6:54 AM
Sergiy - Wednesday, January 24, 2018 3:00 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)

January 24, 2018 at 8:59 am

#1977122
RE: Question Regarding Date logic

Sergiy - Wednesday, January 24, 2018 3:00 AM
So many solutions of different quality to the problem which should never be attempted!Jeff asked...
--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 24, 2018 at 8:37 am

#1977116
RE: Effectiveness

Eric M Russell - Wednesday, January 24, 2018 8:13 AM
Developing software is a lot like operating a kitchen in a restaurant. When...
--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 24, 2018 at 8:34 am

#1977115
RE: Question Regarding Date logic

below86 - Tuesday, January 23, 2018 3:33 PM
Thanks Lynn for the code, more than what Jeff did. 😀 That's a joke...
--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 23, 2018 at 9:34 pm

#1977033
RE: Are the posted questions getting worse?

DesNorton - Tuesday, January 23, 2018 9:07 PM
Lynn Pettis - Tuesday, January 23, 2018 5:54 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)

January 23, 2018 at 9:26 pm

#1977032
RE: Question Regarding Date logic

Lynn Pettis - Tuesday, January 23, 2018 4:11 PM
Oh, when you go back past 1753 the dates may not actually be correct. ...
--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 23, 2018 at 9:22 pm

#1977031
RE: Question Regarding Date logic

jcelko212 32090 - Tuesday, January 23, 2018 5:54 PM
ScottPletcher - Tuesday, January 23, 2018 2:24 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)

January 23, 2018 at 9:06 pm

#1977028

Viewing 15 posts - 13,051 through 13,065 (of 59,099 total)