Jeff Moden

Forum Replies Created

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

RE: Compression estimates

Evgeny Garaev - Wednesday, January 17, 2018 8:23 PM
Jeff Moden - Wednesday, January 17, 2018 5:20...
--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:44 pm

#1976266
RE: UPDATE() function in a trigger

TheSQLGuru - Wednesday, January 17, 2018 4:52 PM
Aaron N. Cutshall - Wednesday, January 17, 2018 1:17 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 17, 2018 at 5:30 pm

#1976256
RE: Compression estimates

It'll be interesting to see someone's face when they run this code even on a giant database right after a service bounce. 😉 A little embedded documentation would go 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)

January 17, 2018 at 5:20 pm

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

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