Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,826 through 12,840 (of 59,095 total)

RE: Need Tutorial on Differential Backup

Seggerman-675349 - Monday, February 26, 2018 1:58 PM
yes, that is what I needed - thanks folks
Not quite. It's a good example 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)

February 26, 2018 at 4:07 pm

#1981209
RE: How to handle very large dataset

NineIron - Monday, February 26, 2018 12:00 PM
See attached.
The query in that execution plan is quite a bit different than what 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)

February 26, 2018 at 12:30 pm

#1981173
RE: JSON performance

Heh... "JSON performance"... Isn't that what they call an "oxymoron"? 😉
--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)

February 26, 2018 at 11:23 am

#1981157
RE: Consequences of making "dbo", directly, the owner of db_datareader schema

Your original posts states that you want to delete the db_datareader role after assigning it's schema to DBA. Since it's a database fixed role, I'm not sure that you could...
--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)

February 26, 2018 at 11:22 am

#1981156
RE: What are SHOWPLAN security risks? Should a query optimizer person (not DBA) have access to it?

IMHO, the two of you make up the "DBA Team". The other person is the "system" DBA and you are the "application" DBA. Both of you need sysadmin privs 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)

February 26, 2018 at 10:57 am

#1981149
RE: Triggers

dastagiri16 - Saturday, February 24, 2018 12:03 AM
Hi Team,
I have created one single trigger to capture information modified by the insert/update/delete commands.
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)

February 24, 2018 at 7:01 am

#1981036
RE: Consequences of making "dbo", directly, the owner of db_datareader schema

goher2000 - Friday, February 23, 2018 1:02 PM
For the fixed database roles such as db_datareader, by default the role and a schema...
--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)

February 23, 2018 at 3:28 pm

#1981015
RE: Recursive Queries

sknox - Friday, February 23, 2018 8:51 AM
Sean Lange - Friday, February 23, 2018 7:17 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)

February 23, 2018 at 2:19 pm

#1981007
RE: Recursive Queries

sknox - Friday, February 23, 2018 6:52 AM
Stewart "Arturius" Campbell - Friday, February 23, 2018 3:44 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)

February 23, 2018 at 2:15 pm

#1981006
RE: Is db_datareader and db_datawriter *typically* all that's needed?

lptech - Thursday, February 22, 2018 11:31 AM
Even db_datareader and datawriter could be too much in today's environment. Do 'most users' really...
--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)

February 22, 2018 at 2:01 pm

#1980856
RE: SQL Database Audit

NicHopper - Wednesday, February 21, 2018 9:37 AM
Steve Jones - SSC Editor - Wednesday, February 21, 2018...
--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)

February 22, 2018 at 11:34 am

#1980820
RE: Today's Random Word!

ManicStar - Thursday, February 22, 2018 11:15 AM
Ed Wagner - Thursday, February 22, 2018 5:58 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)

February 22, 2018 at 11:26 am

#1980818
RE: How would you lock down a SQL DBA to have local admin on the SQL box

ffarouqi - Thursday, February 22, 2018 10:59 AM
Steve Jones - SSC Editor - Thursday, February 22, 2018...
--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)

February 22, 2018 at 11:25 am

#1980816
RE: Is db_datareader and db_datawriter *typically* all that's needed?

Lynn Pettis - Thursday, February 22, 2018 10:54 AM
Yes, db_datareader and db_datawriter could be considered the minimum. The others are not typically...
--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)

February 22, 2018 at 11:22 am

#1980814
RE: Is db_datareader and db_datawriter *typically* all that's needed?

IMHO, the "Gold Standard" would be to not allow any privs to user or apps other than "PUBLIC" and privs to run certain stored procedures.
--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)

February 22, 2018 at 10:26 am

#1980799

Viewing 15 posts - 12,826 through 12,840 (of 59,095 total)

Jeff Moden

Forum Replies Created

RE: Need Tutorial on Differential Backup

RE: How to handle very large dataset

RE: JSON performance

RE: Consequences of making "dbo", directly, the owner of db_datareader schema

RE: What are SHOWPLAN security risks? Should a query optimizer person (not DBA) have access to it?

RE: Triggers

RE: Consequences of making "dbo", directly, the owner of db_datareader schema

RE: Recursive Queries

RE: Recursive Queries

RE: Is db_datareader and db_datawriter typically all that's needed?

RE: SQL Database Audit

RE: Today's Random Word!

RE: How would you lock down a SQL DBA to have local admin on the SQL box

RE: Is db_datareader and db_datawriter typically all that's needed?

RE: Is db_datareader and db_datawriter typically all that's needed?