Jeff Moden

Forum Replies Created

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

RE: Algorithm to combine 2 integer into one value and then disintegrate back into two

I guess I don't understand the desire to partition by two columns, never mind the PeriodYTD column. It would appear that the PERIOD column is based on month ending dates...
--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 pm

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

patrickmcginnis59 10839 - Thursday, October 4, 2018 4:18 PM
REBUILDs remove free space below the Fill Factor and create free space above...
--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 4:42 pm

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

It does exactly what it says so it's not a document error. It "compact{s}... based on the existing fill factor value". The documentation also clearly states that REORGANIZE will 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)

October 4, 2018 at 3:38 pm

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

Jason A. Long - Thursday, October 4, 2018 2:16 PM
How about app developers who don't want to create new tables...
--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 3:04 pm

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

dmbaker - Thursday, October 4, 2018 7:31 AM
And the problem with a stored procedure is that you have to work around Entity...
--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 1:36 pm

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

Stepping back to the original question of "Are Indexes Actually Changes to the System?", let's also consider that I've just run across a 14.5GB index with 16 key columns (8...
--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 1:33 pm

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

Eric M Russell - Thursday, October 4, 2018 12:26 PM
To address the issue of code dependencies on the original Journal table,...
--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:58 pm

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

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