Jeff Moden

Forum Replies Created

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

RE: Are Indexes Actually Changes to the System?

Jason A. Long - Wednesday, October 3, 2018 8:59 PM
Great stuff Jeff. I look forward to seeing (and playing 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 4, 2018 at 7:03 am

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

As a teaser, here's what happens to a supposedly "Append Only" index that is made to suffer "ExpAnsive" updates. Just imagine how low the page density and percent of logical fragmentation...
--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 7:47 pm

#2007994
RE: BCP issues with export data files generated with queryout won't import in tables.

First of all, if your target is another SQL Server, stop using a CSV format. Use the "Native" format. It will be faster to export and faster to import.
--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 4:55 pm

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

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