Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,126 through 13,140 (of 59,099 total)

RE: Customize Software or Process

HighPlainsDBA - Wednesday, January 17, 2018 3:16 PM
Oh man, this is a good one. This is the problem that never seems 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)

January 17, 2018 at 4:46 pm

#1976248
RE: Update Statistics : _WA_Sys_0000000 ... Type

Steve Jones - SSC Editor - Wednesday, January 17, 2018 10:28 AM
Did you manually recreate them?
Nope. The system did when someone ran...
--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 17, 2018 at 11:44 am

#1976170
RE: Backups, Backups, Backups.......

I guess my recommendation would be... to educate the people involved as to what RPO and RTO actually means and what the impact to the business would be for (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)

January 17, 2018 at 10:42 am

#1976166
RE: Update Statistics : _WA_Sys_0000000 ... Type

Steve Jones - SSC Editor - Wednesday, January 17, 2018 7:49 AM
Ignore these stats. If they are useful and always created, 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)

January 17, 2018 at 9:54 am

#1976150
RE: best practice recommendations requested after data purge

SQLJay - Wednesday, January 17, 2018 9:34 AM
Jeff and Sue,
thank you for the recommendations. We'll start looking into index defragmentation and update...
--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 17, 2018 at 9:44 am

#1976148
RE: It's Not Yours

Steve Jones - SSC Editor - Wednesday, January 17, 2018 8:09 AM
Jeff Moden - Wednesday, January 17,...
--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 17, 2018 at 9:33 am

#1976145
RE: It's Not Yours

patrickmcginnis59 10839 - Wednesday, January 17, 2018 8:32 AM
Jeff Moden - Wednesday, January 17, 2018 6:56 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 17, 2018 at 9:28 am

#1976144
RE: It's Not Yours

The title of this article is "Its not yours". While I definitely agree with that, I'm the DBA for the company I work for. That means that I'm charged with...
--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 17, 2018 at 6:56 am

#1976114
RE: Are the posted questions getting worse?

Sergiy - Tuesday, January 16, 2018 7:48 PM
Online shopping leaves number of traces.Which can be used in police investigation in case 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 17, 2018 at 6:50 am

#1976111
RE: SQL Server Unused Index Script

Sue_H - Tuesday, January 16, 2018 12:11 PM
Jeff Moden - Tuesday, January 16, 2018 11:41 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 17, 2018 at 6:35 am

#1976109
RE: Transaction log issue

WhiteLotus - Tuesday, January 16, 2018 5:13 PM
Guys...
I think I need to change the autogrowth setting as currently is very small ....
--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 16, 2018 at 6:06 pm

#1976085
RE: Transaction log issue

RandomStream - Tuesday, January 16, 2018 5:33 PM
How do you know that there is no open transaction?
Auto growth rate has nothing...
--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 16, 2018 at 6:02 pm

#1976084
RE: auditing using extended events

fizzleme - Tuesday, January 16, 2018 11:10 AM
Ok. Thanks for the advice. This sounds like a pain. However we need to determine...
--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 16, 2018 at 11:47 am

#1976031
RE: Use inserted identity field value to link to identity field from source table question.

You can certainly do this with OUTPUT or MERGE.... the trick is that you need something in your insert to be common with the original table you're inserting from 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)

January 16, 2018 at 11:45 am

#1976030
RE: SQL Server Unused Index Script

Agreed. I've reported this as a "Terms of use" violation for possible plagiarism. It explains a lot about several of this user's recent posts not having any decent information about...
--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 16, 2018 at 11:41 am

#1976029

Viewing 15 posts - 13,126 through 13,140 (of 59,099 total)