Jeff Moden

Forum Replies Created

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

RE: I am struggling with selecting specific information out of a strings

nick.hinton - Tuesday, October 23, 2018 9:49 AM
It works in a 2008 r2 instance, and as I say here is a post...
--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 10:40 am

#2010820
RE: index scan where seek expected

ScottPletcher - Tuesday, October 23, 2018 10:13 AM
jontris - Tuesday, October 23, 2018 2:49 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 23, 2018 at 10:25 am

#2010811
RE: I am struggling with selecting specific information out of a strings

randyetheridge - Tuesday, October 23, 2018 8:39 AM
thanks, both of those answers will take me some time to understand. I ended up...
--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 9:30 am

#2010793
RE: Naming Conventions for SQL Server Objects

JustMarie - Tuesday, October 23, 2018 8:09 AM
Ken McKelvey - Monday, October 22, 2018 9:52 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 23, 2018 at 8:45 am

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

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