Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,441 through 10,455 (of 59,095 total)

RE: Run away logical reads on stored proc causing timeouts.

I guess my first question would be, when is the last time stats were rebuilt for this index? And, remember, logical fragmentation means very little once something is in memory. ...
--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)

December 5, 2018 at 9:44 am

#2015576
RE: Run away logical reads on stored proc causing timeouts.

Eric M Russell - Wednesday, December 5, 2018 7:50 AM
What makes it a very hot table is when a user enters editing,...
--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)

December 5, 2018 at 9:42 am

#2015575
RE: Cost estimation for SQL Server Azure VMs

Matt Miller (4) - Tuesday, December 4, 2018 3:04 PM
Jeff Moden - Monday, December 3, 2018 10:33...
--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)

December 5, 2018 at 6:51 am

#2015555
RE: Values are randomly set to NULL

Edvard KorsbÃ¦k - Wednesday, December 5, 2018 12:11 AM
Dear Jeff!
Both true and not.
It is a part of a 3'party template, but 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)

December 5, 2018 at 6:16 am

#2015551
RE: Values are randomly set to NULL

Is this, by any chance, a table provided by 3rd party software? If I had to guess, it looks like someone did a very intentional "cleanup" of possible users that...
--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)

December 4, 2018 at 11:22 pm

#2015536
RE: Index rebuild issues

bennehoff.bradley - Tuesday, December 4, 2018 1:54 PM
They rebuild but still remain fragmented. I have been working on a script to work...
--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)

December 4, 2018 at 10:26 pm

#2015532
RE: when to use clustered vs nonclustered indexes

Scott Coleman - Tuesday, December 4, 2018 3:37 PM
A clustered index must be unique, but not necessarily in the columns you use...
--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)

December 4, 2018 at 8:28 pm

#2015528
RE: Sort comma separated value in SQL Table

Eirikur Eiriksson - Tuesday, December 4, 2018 9:09 AM
Here is what I did on the subject
😎
Reaping the benefits 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)

December 4, 2018 at 9:16 am

#2015459
RE: Cost estimation for SQL Server Azure VMs

Deepak Sahu - Tuesday, December 4, 2018 4:13 AM
Hi Jeff,
Storage Transactions are the number of requests performed against your storage account.
Storage Transactions...
--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)

December 4, 2018 at 8:22 am

#2015441
RE: Cost estimation for SQL Server Azure VMs

Ok... what does a "Storage Transaction" actually consist of? I ask because many of the hits are pretty large batches. By the same token, we also have tens of million...
--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)

December 3, 2018 at 10:33 pm

#2015400
RE: sql performance question

Just my humble opinion but (provided I'm not missing some awesome trick) my initial thought is that this is is a "manhole cover" question. It's littered with supposed "worst practices" (DISTINCT, 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)

December 3, 2018 at 10:21 pm

#2015397
RE: Remove non alpha chars from a column

Shifting gears a bit,.. Lordy, I miss Dwain. :unsure:
--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)

December 3, 2018 at 8:53 pm

#2015392
RE: Remove non alpha chars from a column

Heh... here I go ago... necro'ing the same wicked old post.
@DonlSimpson ... Try the following and see why I prefer not 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)

December 3, 2018 at 8:49 pm

#2015391
RE: Need index suggestion

Still looking for why anyone would find the sorting to be useful considering the output and the fact that there's noting to preserve that order if used elsewhere.
--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)

December 3, 2018 at 8:41 am

#2015329
RE: How to split comma separated values stored in XML node Without using function- SQL Server 2012

Patchai001 - Monday, December 3, 2018 8:26 AM
This was the requirement from client not to use function as this query will be...
--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)

December 3, 2018 at 8:39 am

#2015328

Viewing 15 posts - 10,441 through 10,455 (of 59,095 total)