Jeff Moden

Forum Replies Created

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

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
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Friday, September 15, 2017 6:36 AM
paul s-306273 - Friday, September 15, 2017 4: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)

September 15, 2017 at 6:09 pm

#1959680
RE: Are the posted questions getting worse?

paul s-306273 - Friday, September 15, 2017 4:21 AM
Jeff Moden - Thursday, September 14, 2017 9:10 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 6:06 pm

#1959679
RE: The struggle to renormalize data

Ah... ok. Then we're still talking about the same methodology of having some "unique" single character delimiter. The unfortunate part of using a pipe or any other character and "standard"...
--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 5:58 pm

#1959676
RE: Fill Factor on Clustered Index

The FILL FACTOR really only comes into play if you make the mistake of rebuilding or reorganizing the Clustered Index. Stop that and let the "Natural Fill Factor" be 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)

September 15, 2017 at 11:05 am

#1959635

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