Jeff Moden

Forum Replies Created

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

RE: Display 'blank' cell when it is null.

jcelko212 32090 - Friday, October 19, 2018 7:35 PM
keneangbu - Friday, October 19, 2018 2:03 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 20, 2018 at 6:41 pm

#2010508
RE: Naming Conventions for SQL Server Objects

As for the CMS standards that you provided a link to... there's some good advice here and there in it but, for the most part, BLEAH! Imagine using Hungarian Notation...
--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 20, 2018 at 1:32 pm

#2010504
RE: Naming Conventions for SQL Server Objects

Heh... maybe "Capitialize() instead of the past tense "capitalized". I also hate the use of all upper case or all lower case for user defined object names, especially in this...
--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 20, 2018 at 1:08 pm

#2010502
RE: A $3 Billion Donation

Jonathan AC Roberts - Friday, October 19, 2018 4:21 AM
Jeff Moden - Thursday, October 18, 2018 9:32...
--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:43 am

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

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