Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,876 through 10,890 (of 59,095 total)

RE: Can anyone suggest a SQL Server Advanced course?

Data Cruncher - Friday, October 19, 2018 1:53 AM
allan.ford17 - Thursday, October 18, 2018 5: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)

October 19, 2018 at 7:41 am

#2010426
RE: Same Execution Plan different stats

anvegger - Friday, October 19, 2018 7:16 AM
BTW that INDEX hint along with an INDEX itself did not change execution plan or...
--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)

October 19, 2018 at 7:34 am

#2010423
RE: Find and replace third occurrence of the string

saravanatn - Thursday, October 18, 2018 8:33 PM
ScottPletcher - Thursday, October 18, 2018 2:25 PM
I...
--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)

October 18, 2018 at 8:44 pm

#2010351
RE: Same Execution Plan different stats

Jack Corbett - Thursday, October 18, 2018 7:30 PM
I know you have said you updates stats, but did you do...
--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)

October 18, 2018 at 8:14 pm

#2010346
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 6:30 PM
Jeff Moden - Thursday, October 18, 2018 5:53 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)

October 18, 2018 at 6:54 pm

#2010342
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 4:33 PM
That would of been my thought as well but unfortunately I don't see that right...
--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)

October 18, 2018 at 5:53 pm

#2010335
RE: Same Execution Plan different stats

anvegger - Thursday, October 18, 2018 3:06 PM
Let me re-iterate the issue:
1. I have the same INSTANCE running on the virtual box
2....
--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)

October 18, 2018 at 4:06 pm

#2010322
RE: Find and replace third occurrence of the string

ScottPletcher - Thursday, October 18, 2018 2:25 PM
I suggest starting with your actual solution, not listing things you would not do first. ...
--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)

October 18, 2018 at 4:01 pm

#2010321
RE: Table growing excessively when updating column

gerben.scherpenzeel - Thursday, October 18, 2018 2:34 AM
Jeff Moden - Monday, October 15, 2018 2:48 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)

October 18, 2018 at 11:24 am

#2010275
RE: Same Execution Plan different stats

When is the last time you updated statistics on the databases and have you been using FULLSCAN or something else?
--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)

October 18, 2018 at 11:01 am

#2010267
RE: Convert data to numeric/decimal

Jonathan AC Roberts - Thursday, October 18, 2018 10:17 AM
GrassHopper - Thursday, October 18, 2018 10:09 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)

October 18, 2018 at 10:57 am

#2010265
RE: Using your critical eye to see something positive

Jason- - Thursday, October 18, 2018 6:46 AM
Jeff Moden - Thursday, October 18, 2018 12: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)

October 18, 2018 at 10:49 am

#2010261
RE: Using your critical eye to see something positive

Jeff Mlakar - Thursday, October 18, 2018 9:24 AM
Jeff Moden - Thursday, October 18, 2018 9:11 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)

October 18, 2018 at 9:37 am

#2010247
RE: A $3 Billion Donation

Eric M Russell - Thursday, October 18, 2018 9:10 AM
Maybe Microsoft is wanting to following the casino business model where free food...
--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)

October 18, 2018 at 9:32 am

#2010246
RE: Using your critical eye to see something positive

Jeff Mlakar - Thursday, October 18, 2018 8:57 AM
I like to look at this phenomenon of the negative DBA like this: the...
--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)

October 18, 2018 at 9:12 am

#2010241

Viewing 15 posts - 10,876 through 10,890 (of 59,095 total)