Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,086 through 11,100 (of 59,099 total)

RE: Are Indexes Actually Changes to the System?

Aaron N. Cutshall - Wednesday, October 3, 2018 10:59 AM
Jeff Moden - Wednesday, October 3, 2018 10:40...
--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 3, 2018 at 11:07 am

#2007905
RE: Are Indexes Actually Changes to the System?

Aaron N. Cutshall - Wednesday, October 3, 2018 9:26 AM
Don't hold back, Jeff. Tell us how you REALLY feel! 😛
You raise good...
--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 3, 2018 at 10:40 am

#2007897
RE: Max size file in BCP process

SATYA R - Wednesday, October 3, 2018 9:24 AM
@jeff : Bulk insert is much faster if file exit in Sql server. but...
--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 3, 2018 at 9:29 am

#2007886
RE: Are Indexes Actually Changes to the System?

I'm all for change processes like that which Andrew posted and we have it all documented in our WIKI, which also includes the development process and the peer review process. ...
--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 3, 2018 at 9:20 am

#2007882
RE: Max size file in BCP process

To be honest, I wouldn't use BCP for imports. Bulk Insert is a little faster.
To be equally honest, I'm also not a big fan of SSIS for this...
--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 3, 2018 at 8:48 am

#2007878
RE: Count values for first day of past n months

DataAnalyst011 - Thursday, September 27, 2018 9:26 PM
I have calculate 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)

October 3, 2018 at 8:41 am

#2007877
RE: Count values for first day of past n months

Ah... be careful, Laurie. You're using rCTEs (Recursive CTEs) that produce an incremental count and they're slower than a well written While Loop and use 9 times the number 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)

October 3, 2018 at 8:37 am

#2007876
RE: Index Seek is costing a lot in execution plan

vicesjr - Wednesday, October 3, 2018 12:31 AM
Thanks Jeff for taking a look at this.
You are right we will have to revisit...
--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 3, 2018 at 8:31 am

#2007874
RE: Are the posted questions getting worse?

ChrisM@Work - Wednesday, October 3, 2018 2:55 AM
Where are the beers???
What... you missed the side profile of my gut in 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 3, 2018 at 8:15 am

#2007869
RE: Insert records in to table that has primary key identity seed

scotsditch - Tuesday, October 2, 2018 12:51 PM
Can I ... ?
Did you try it before asking?
--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 2, 2018 at 7:39 pm

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

elea.grig - Monday, October 1, 2018 12:41 PM
sgmunson - Monday, October 1, 2018 8:09 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 2, 2018 at 7:32 pm

#2007817
RE: Index Seek is costing a lot in execution plan

The outer apply with the TOP 1 is killing you. It's doing 8443 seeks on the color table. There's only 8443 rows in the whole table.
Of course,...
--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 2, 2018 at 7:21 pm

#2007816
RE: Max size file in BCP process

SATYA R - Tuesday, October 2, 2018 7:22 AM
HI Jeff,
thanks for your response.
Can you please leave your comments on below points.
3. 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 2, 2018 at 1:33 pm

#2007784
RE: Give Up on Natural Primary Keys

DinoRS - Tuesday, October 2, 2018 10:30 AM
Jeff Moden - Tuesday, October 2, 2018 8:24 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 2, 2018 at 1:09 pm

#2007779
RE: Wrong estimate when inserting in multiple sessions

Bouke Bruinsma - Tuesday, October 2, 2018 8:41 AM
There must be a way for you guys to reproduce this. I have now...
--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 2, 2018 at 1:03 pm

#2007777

Viewing 15 posts - 11,086 through 11,100 (of 59,099 total)