Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,071 through 11,085 (of 59,095 total)

RE: Are Indexes Actually Changes to the System?

Jason A. Long - Thursday, October 4, 2018 11:51 AM
Once again...Thank you for the clarification. That definitely helps put things into...
--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 12:53 pm

#2008187
RE: Are the posted questions getting worse?

Thom A - Thursday, October 4, 2018 9:44 AM
At what point would you suggest that someone is no longer "new to SQL"?...
--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 9:54 am

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

Aaron N. Cutshall - Thursday, October 4, 2018 9:24 AM
Jeff Moden - Thursday, October 4, 2018 8:39...
--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 9:45 am

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

If you have a reliable method of determining which specific columns are most responsible for the page splits on a given index, it should be a simple matter...
--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 9:40 am

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

Aaron N. Cutshall - Thursday, October 4, 2018 7:21 AM
Jeff,
I have to question your statement about GUIDs used in a clustered...
--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 8:39 am

#2008090
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

Lowell - Monday, September 24, 2018 7:53 AM
don't forget the basics: make sure you've added SET NOCOUNT ON at the top 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 4, 2018 at 7:26 am

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

dmbaker - Thursday, October 4, 2018 6:51 AM
If you're using Entity Framework (not EF Core) I'd consider using a view, not 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:21 am

#2008044
RE: Max size file in BCP process

SATYA R - Thursday, October 4, 2018 6:16 AM
Hi Excerpts ,
I have installed BCP utility in Linux server.
when am executing below command...
--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:18 am

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

Viewing 15 posts - 11,071 through 11,085 (of 59,095 total)