Jeff Moden

Forum Replies Created

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

RE: Audit systems: a good idea or a mess to maintain?

William Rayer - Tuesday, February 27, 2018 4:20 AM
I use a simple approach which works well:
1. Each table being audited should have...
--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 27, 2018 at 7:45 am

#1981284
RE: Max degree of parallelism - Query costs

Although the COST of the query is a decent indicator during troubleshooting, it is just an estimate. The only way to tell if there's really been a change for...
--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 27, 2018 at 7:43 am

#1981283
RE: Need Tutorial on Differential Backup

GilaMonster - Tuesday, February 27, 2018 1:02 AM
Jeff Moden - Monday, February 26, 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)

February 27, 2018 at 6:52 am

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

peter_parker - Monday, February 26, 2018 2:01 PM
Thanks for the replies both. They are both pretty useful and generally my thought process.
It...
--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:13 pm

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

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