Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,296 through 14,310 (of 59,101 total)

RE: Job failing with maximum row size exceeds the allowed maximum of 8060 bytes.

Database admin(DBA) - Tuesday, September 19, 2017 2:10 PM
Lynn Pettis - Tuesday, September 19, 2017 1:12 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)

September 19, 2017 at 4:40 pm

#1960054
RE: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

Thanks for the feedback both on your fix and on nonRBAR solutions, Geoff. I appreciate it.
--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)

September 19, 2017 at 4:10 pm

#1960051
RE: The struggle to renormalize data

David.Poole - Monday, September 18, 2017 8:15 AM
I'm just not convinced that something that can be achieved with bcp should be replaced...
--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)

September 18, 2017 at 5:22 pm

#1959888
RE: Mortgage amortization table

ScottPletcher - Monday, September 18, 2017 10:00 AM
I don't think this is really an issue, as a practical matter. Interest is computed daily,...
--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)

September 18, 2017 at 5:16 pm

#1959887
RE: Performance Tuning with Nvarchar(max)

krishnavamshi24 - Friday, September 15, 2017 1:11 PM
Hi Folks,
I have a performance issue on view that returns 7 columns which are of...
--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)

September 18, 2017 at 9:35 am

#1959828
RE: Mortgage amortization table

Shifting to DECIMAL has it's own problems... like silent truncation to 6 decimal places in certain cases. I wish MS would figure out that systems do actually have math-coprocessors built...
--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)

September 18, 2017 at 9:32 am

#1959826
RE: HIERARCHYID DataType and Referential Integrity

kramaswamy - Saturday, September 16, 2017 10:52 AM
Hi guys,
Not usually one to bump a thread, but this same topic came up again...
--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)

September 18, 2017 at 9:27 am

#1959825
RE: Need to use a script data source to pull in 10,000+ characters of data in one Excel column

I have no clue how to fix this because I've never run into it before. I am interested, though, so this will act as a "bump" for your 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)

September 18, 2017 at 8:33 am

#1959810
RE: Occasional mysterious time outs on SQL Server db table

Sergiy - Thursday, September 14, 2017 4:52 AM
You mentioned "edit/update spatial data."And then you said "no locks". Sorry, it cannot be true.It...
--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)

September 18, 2017 at 8:26 am

#1959805
RE: Voting for Change

I've found that CONNECT is pretty useless for suggestions unless that suggestion can be used for serious marketing. It's a somewhat beneficial dictatorship. Considering some of the suggestions, that's not...
--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)

September 18, 2017 at 8:14 am

#1959798
RE: Which is GOOD/BETTER out of two ways of writing a query ??

Thom A - Monday, September 18, 2017 3:13 AM
This might seem a silly thing to say, but what have you done 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)

September 18, 2017 at 7:58 am

#1959790
RE: Mortgage amortization table

naveentiwari20 - Sunday, September 17, 2017 10:49 PM
Best Loan Amoritzation schedule at below link
http://www.studycorners.com/make-emi-loan-sql-server-studycorners/
Heh.... "Best"? I was interested to see how...
--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)

September 18, 2017 at 7:44 am

#1959782
RE: The struggle to renormalize data

David.Poole - Monday, September 18, 2017 1:21 AM
If you have known columns represented in fixed width or delimited file there is so...
--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)

September 18, 2017 at 7:30 am

#1959775
RE: The struggle to renormalize data

xsevensinzx - Friday, September 15, 2017 6:00 PM
Chris Harshman - Friday, September 15, 2017 7: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)

September 15, 2017 at 11:31 pm

#1959683
RE: Are the posted questions getting worse?

TomThomson - Friday, September 15, 2017 6:18 PM
Jeff Moden - Thursday, September 14, 2017 7:37 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)

September 15, 2017 at 10:33 pm

#1959682

Viewing 15 posts - 14,296 through 14,310 (of 59,101 total)