Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,786 through 10,800 (of 59,102 total)

RE: seperate data in 1 row

Krasavita - Thursday, October 25, 2018 10:24 AM
Hello
HOw can I separate this data
I have buch of emails in a row, 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 29, 2018 at 9:06 pm

#2011634
RE: Extract string between delimiters

Correct. It doesn't always work. If you have a trailing empty string (which is fairly common), for example, it pretty much renders it useless.
--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 29, 2018 at 8:48 pm

#2011633
RE: Who Likes NULL?

Just to use a different spoon to stir the pot a little, it's amazing how bad the use of NULL is when you work with indexes. For example, you can...
--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 29, 2018 at 7:47 pm

#2011631
RE: How to build an app with GUI that works with SQL Server?

@patrick-2,
Heh... it's so odd. You and I actually are joined at the hip on a lot of things.
On the subject of the original app, I agree...
--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 29, 2018 at 7:06 pm

#2011630
RE: Sql 2017 upgrade from 2014 with sequential numbers

ebeng - Monday, October 29, 2018 5:00 AM
Thanks Jeff
Ill check out the Estimator also
Whether it fixes it or not, the Quirky 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)

October 29, 2018 at 6:55 am

#2011512
RE: Changing 1 or + in a telephone number to the correct format

What about the spaces between area code, exchange, and line that were originally posted?
--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 29, 2018 at 6:51 am

#2011511
RE: Where is the Performance Bottleneck?

With the understanding that it resets when the SQL Server Service bounces and that something can be driven out of cache, I'd bet that it's code problems that need 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)

October 29, 2018 at 6:48 am

#2011510
RE: Can't remove multiple char(32) strings

ChrisM@Work - Monday, October 29, 2018 3:19 AM
Jeff Moden - Friday, October 26, 2018 9:05 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 29, 2018 at 6:42 am

#2011507
RE: Tables using ANSI_NULLS

Mike Scalise - Friday, October 26, 2018 1:54 PM
Phil Parkin - Friday, October 26, 2018 1: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 28, 2018 at 3:02 pm

#2011472
RE: How to build an app with GUI that works with SQL Server?

And sorry for the quote blocks not encompassing everything that I intended. It would appear that the forum code was written as so many other have and I've gotten used...
--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 28, 2018 at 1:11 pm

#2011468
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Friday, October 26, 2018 10:39 AM
All you've done is advocate the status quo, which is broken. Anyone that can build...
--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 28, 2018 at 1:04 pm

#2011467
RE: Sql 2017 upgrade from 2014 with sequential numbers

ebeng - Friday, October 26, 2018 12:47 PM
Hi
Just figured out it had nothing to do with the SQL upgrade but it does...
--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 27, 2018 at 12:40 pm

#2011455
RE: Are the posted questions getting worse?

Sergiy - Friday, October 26, 2018 7:52 PM
jasona.work - Thursday, October 25, 2018 12:15 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 27, 2018 at 12:31 pm

#2011454
RE: Splitting value into multiple rows based on size variable

Eirikur Eiriksson - Saturday, October 27, 2018 9:27 AM
Jeff Moden - Saturday, October 27, 2018 8:29...
--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 27, 2018 at 12:28 pm

#2011453
RE: Splitting value into multiple rows based on size variable

jcelko212 32090 - Friday, October 26, 2018 3:26 PM
Jackie Lowery - Friday, October 26, 2018 11: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 27, 2018 at 8:29 am

#2011449

Viewing 15 posts - 10,786 through 10,800 (of 59,102 total)