Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 59,091 total)

Reply To: slow query

Jeffrey Williams wrote:
Could you post the plan here: https://www.brentozar.com/pastetheplan/
Frederico attached a converted copy as a ZIP file.
--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)

August 10, 2020 at 8:18 pm

#3778751
Reply To: Previous row where condition exists

I've been playing with this some more, Scott. It turns out that the Partitioned COUNT(*) is just freakin' nasty (creates 145 extra reads on a 2 page table) compared 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)

August 10, 2020 at 2:37 pm

#3778664
Reply To: Are the posted questions getting worse?

jonathan.crawford wrote:
How would Microsoft actually handle this case though, without disabling the ability to convert MAR1 into the 1st of March for the rest of the users? If the trick...
--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)

August 10, 2020 at 2:30 pm

#3778651
Reply To: Are the posted questions getting worse?

OMG! The world has gone completely mad. If you still don't think that spreadsheets rule the world, read the following article. The "punch line" after the title of the article...
--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)

August 10, 2020 at 1:53 pm

#3778628
Reply To: slow query

frederico_fonseca wrote:
having a sqlplan won't give you the sql query (the one that matters) on this case as a view is being used.
main query is a view - I would...
--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)

August 10, 2020 at 1:47 pm

#3778625
Reply To: slow query

Eirikur Eiriksson wrote:
Jeff Moden wrote:
For me, the link provided by the OP doesn't point to an SQLPlan file. It points to a file but SQL Server doesn't recognize it as an SQLPlan.
Eirikur,...
--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)

August 10, 2020 at 1:13 pm

#3778618
Reply To: slow query

For me, the link provided by the OP doesn't point to an SQLPlan file. It points to a file but SQL Server doesn't recognize it as an SQLPlan.
Eirikur, what did...
--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)

August 9, 2020 at 5:18 pm

#3778488
Reply To: How to be an MVP

And, PLEASE... remember that the MVP award is a "Service Award". Although a great many (for example) SQL Server MVPs (such as the author of this article, Kathi Kellenberger and...
--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)

August 9, 2020 at 4:24 am

#3778451
Reply To: Mitigating STIGs

Anything that you write for code can be changed by anyone with SysAdmin privs. No pun intended, but if you want the STIG to "stick", you're going to have 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)

August 8, 2020 at 12:08 am

#3778336
Reply To: Previous row where condition exists

ScottPletcher wrote:
It has no dependencies because it sorts the values again (as I understood the q). If you have a lot of data that has already been sorted, that may...
--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)

August 7, 2020 at 4:56 pm

#3778250
Reply To: how to find why the stored procedure took time to execute

This is one of the reasons why I use RAISERROR('Section: %s Duration(ms): %u',0,0,@SectionName,@Duration) WITH NOWAIT: in virtually ever section of stored procedures I write to write section name, duration and,...
--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)

August 7, 2020 at 1:32 pm

#3778186
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
I have a standing offer on LinkedIn to promote anyone looking for work. I'll double down on that for Threadizens. I can actually say I know that you know...
--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)

August 7, 2020 at 1:20 pm

#3778183
Reply To: Are the posted questions getting worse?

Step 1, get a much nicer picture for linked in and smile a little bit.
Step 2, update your recent history and make sure you list your major accomplishments!
--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)

August 7, 2020 at 3:58 am

#3778073
Reply To: Previous row where condition exists

p.s. And what I was getting at is you could do your RowNum at the same time if you really need it but I'm thinking that sorting by ID is...
--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)

August 7, 2020 at 3:02 am

#3778067
Reply To: Previous row where condition exists

Ok... give this a try and let me know if this does the trick or not. I left your RowNum in there instead of sorting by the ID. I 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)

August 7, 2020 at 2:27 am

#3778063

Viewing 15 posts - 6,646 through 6,660 (of 59,091 total)