Jeff Moden

Forum Replies Created

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

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

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