Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,771 through 10,785 (of 59,099 total)

RE: seperate data in 1 row

Thanks for your code but can you please do as I asked and provide the sample data in a readily consumable format as I did in my example? If you...
--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 30, 2018 at 8:36 am

#2011701
RE: seperate data in 1 row

If you want to stop going back and forth with incremental questions, please take the time to post the code to create a table and populate it as I did...
--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 30, 2018 at 8:18 am

#2011693
RE: seperate data in 1 row

Krasavita - Tuesday, October 30, 2018 7:09 AM
I found problem in email it goes like that:'%@rs.org
%'
eamplee:
( N'ba@rs.org
julia.leis@rs.org' )
how can this 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 30, 2018 at 8:16 am

#2011691
RE: Skills for Everyone in Tech

drew.allen - Tuesday, October 30, 2018 7:41 AM
Jeff Moden - Tuesday, October 30, 2018 6:39 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 30, 2018 at 8:01 am

#2011686
RE: Skills for Everyone in Tech

If knowing how to program in one language basically means that, with some syntax changes, you know how to program in every language, I wonder why so many people have...
--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 30, 2018 at 6:39 am

#2011664
RE: H?ow to save Word file as varbinary data into SQL server?

adonetok - Tuesday, October 30, 2018 5:21 AM
For security reason, some Word files (DOC/DOCX) can't save into file server.
How to save them...
--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 30, 2018 at 6:28 am

#2011663
RE: Where is the Performance Bottleneck?

p.p.s. And, yes... I agree with the others. If you're only seeing a 10MB transfer rate, something is seriously wrong. We saw such a thing during one of our migrations...
--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 30, 2018 at 6:23 am

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

gvoshol 73146 - Tuesday, October 30, 2018 5:45 AM
Do you know if the incoming numbers will always have 4 groupings with a...
--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 30, 2018 at 6:16 am

#2011660
RE: Where is the Performance Bottleneck?

p.s. Don't forget about the possible serious problems that can occur with changes to collation in regards to TempDB. I've not personally witnessed such a thing because I've not done...
--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 30, 2018 at 6:13 am

#2011659
RE: Where is the Performance Bottleneck?

alex.sqldba - Tuesday, October 30, 2018 4:26 AM
Jeff this is an entirely unused server, and is purely being used for testing 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 30, 2018 at 6:10 am

#2011658
RE: Today's Random Word!

Jason A. Long - Monday, October 29, 2018 8:43 PM
Hugo Kornelis - Monday, October 29, 2018 4:26...
--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:51 pm

#2011636
RE: New to SQL Queries - 'Select the values that are possible but not present'

Matt Miller (4) - Monday, October 29, 2018 9:56 AM
Same Idea as Jonathan's query, I just prefer this for readability (which is...
--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:34 pm

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

Viewing 15 posts - 10,771 through 10,785 (of 59,099 total)