Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 59,072 total)

Reply To: Rebuild or Reorganize index

ScottPletcher wrote:
Erland Sommarskog wrote:
But, yes, depending in which way your index is disorganised, REORGANIZE can mean a lot of operations, as it performs a bubble sort of the file.
I don't think...
--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)

July 21, 2020 at 1:11 am

#3771618
Reply To: Changing Computer Retail

Ralph Hightower wrote:
Ah, nostalgia. I miss BYTE magazine.
And "Computer Shopper".
--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)

July 20, 2020 at 1:39 pm

#3771326
Reply To: Loading 20% of an index in to memory to get a small % of the table's data

Actually, 100% can be generated using a little dynamic SQL, sys.columns, and sys.indexes. I wrote some code for work that people are using. I'll see if I can find 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)

July 20, 2020 at 12:56 pm

#3771300
Reply To: Rebuild or Reorganize index

Man, thanks for the example, Erland. Great stuff and timely, as well. We just installed some 3rd party software where they required the database the software uses to be snapshot...
--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)

July 19, 2020 at 4:12 pm

#3771154
Reply To: Rebuild or Reorganize index

Erland... Before I spend a lot of time looking for it, do you have a link handy that talks about that problem?
--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)

July 18, 2020 at 11:25 pm

#3771111
Reply To: Rebuild or Reorganize index

Erland Sommarskog wrote:
Another thing, I that I did not observe until today, which is a quite important difference is this: If you have any form or snapshot enabled (and that includes...
--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)

July 18, 2020 at 11:19 pm

#3771110
Reply To: SSMS v.18 slow? Is it me or....?

imgn8sn wrote:
I also have been having so many issue with SSMS load times, 30 seconds or more to refresh Tables list, or to Edit table, right-click and wait a life...
--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)

July 18, 2020 at 9:13 pm

#3771102
Reply To: spill to tempdb problem

zamani 41951 wrote:
Friends, I've reached to a good improvement.
I destroyed fragmentation for table Groups_Roles Table. Result was very good. My goal procedure removed from SQL Serve Profiler with more than 3...
--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)

July 18, 2020 at 8:40 pm

#3771101
Reply To: spill to tempdb problem

zamani 41951 wrote:
I've removed PK of LegalReferrence Table. Logical Read reduced for this table very good.
I'm thinking the reason why that worked is simply because that caused a rebuild of related...
--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)

July 18, 2020 at 8:39 pm

#3771100
Reply To: Practice identifying results from dml queries

Phil Parkin wrote:
dbgaragedays wrote:
Identifying results meaning...
Given a sample database schema and DML query provided, I have to come up with the results of the sample query.
This is a section of 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)

July 18, 2020 at 8:07 pm

#3771098
Reply To: Query

Heh... I'm still waiting to hear back from the OP with an answer to my question! 😉
--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)

July 17, 2020 at 9:25 pm

#3770984
Reply To: Rebuild or Reorganize index

ScottPletcher wrote:
REORGANIZE is not meant to reduce total / overall I/O...
Yep... Totally agree... that's one of the many reasons why I avoid it like the plague. 😀
Totally agreed on 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)

July 17, 2020 at 9:19 pm

#3770983
Reply To: Loading 20% of an index in to memory to get a small % of the table's data

Because then your triggers don't have to be coded to do the conversions to VARCHAR().
--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)

July 17, 2020 at 4:30 pm

#3770899
Reply To: Rebuild or Reorganize index

That was the exact scenario I had with the log file blow out that I described. It was an ever increasing index that suffered only from DELETEs. It wasn't an...
--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)

July 17, 2020 at 4:28 pm

#3770896
Reply To: Loading 20% of an index in to memory to get a small % of the table's data

Thanks for taking the time to explain that, Julian.
Shifting gears a bit, since none of the VARCHAR(3500) columns are actually worth a hoot in an index, you might want 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)

July 17, 2020 at 3:35 pm

#3770876

Viewing 15 posts - 6,736 through 6,750 (of 59,072 total)