Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,846 through 10,860 (of 59,095 total)

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

keneangbu - Tuesday, October 23, 2018 7:30 AM
Jeff, thanks for the interesting takeaway about STR(). For your question about why I need...
--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 23, 2018 at 8:35 am

#2010785
RE: badly perfoming query when IS NOT NULL used in the WHERE clause

solus - Tuesday, October 23, 2018 4:13 AM
position.loadshape is varchar(64) and its nullable
Then instead of using IS NOT NULL, try the following...
--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 23, 2018 at 6:22 am

#2010746
RE: badly perfoming query when IS NOT NULL used in the WHERE clause

Hold the phone a minute, please. What is the datatype of the position.loadshape column? If it's a numeric datatype, what is the minimum value that it can be?
--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 22, 2018 at 8:36 pm

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

keneangbu - Monday, October 22, 2018 8:38 AM
Thank you all! FYI ~ someone also suggested this along with the description:
[code...
--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 22, 2018 at 8:26 pm

#2010717
RE: Naming Conventions for SQL Server Objects

drew.allen - Monday, October 22, 2018 3:24 PM
David Walker-278941 - Monday, October 22, 2018 8:47 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 22, 2018 at 8:16 pm

#2010716
RE: index scan where seek expected

ScottPletcher - Monday, October 22, 2018 4:05 PM
Jeff Moden - Monday, October 22, 2018 3:56 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 22, 2018 at 8:06 pm

#2010713
RE: index scan where seek expected

ScottPletcher - Monday, October 22, 2018 11:25 AM
jontris - Monday, October 22, 2018 10:21 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 22, 2018 at 3:56 pm

#2010702
RE: Deleting data from a table ... quickly

ScottPletcher - Monday, October 22, 2018 2:05 PM
Lynn Pettis - Monday, October 22, 2018 1:51 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 22, 2018 at 3:48 pm

#2010700
RE: Naming Conventions for SQL Server Objects

David Walker-278941 - Monday, October 22, 2018 2:39 PM
drew.allen - Monday, October 22, 2018 9:43 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 22, 2018 at 3:43 pm

#2010699
RE: Inserting from temp table to linked server

Hmmmmm.... pulling data from production and putting it on another server... sounds like a security issue just waiting to happen to me.
--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 22, 2018 at 12:14 pm

#2010664
RE: Deleting data from a table ... quickly

ScottPletcher - Monday, October 22, 2018 11:21 AM
Just delete the rows. If it's not that many rows, it's more work than it's...
--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 22, 2018 at 11:52 am

#2010659
RE: Naming Conventions for SQL Server Objects

Jonathan AC Roberts - Monday, October 22, 2018 10:06 AM
David Walker-278941 - Monday, October 22, 2018 8:47...
--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 22, 2018 at 11:16 am

#2010647
RE: Strategy advice for storing Personal Identifiable Information

It's not that easy. You have to understand the whole gambit of things including the real meaning of protecting data at rest as well as encryption of the sensitive columns...
--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 22, 2018 at 9:06 am

#2010598
RE: The best Book to learn ADF

Grant Fritchey - Monday, October 22, 2018 6:41 AM
There are exceedingly few books on any topic in Azure because it moves too...
--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 22, 2018 at 7:16 am

#2010572
RE: Anyone see a problem with this?

Sergiy - Monday, October 22, 2018 5:08 AM
Jeff Moden - Monday, October 22, 2018 4: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)

October 22, 2018 at 6:41 am

#2010564

Viewing 15 posts - 10,846 through 10,860 (of 59,095 total)