Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,606 through 1,620 (of 59,067 total)

Reply To: simple query question

ratbak wrote:
That would happen if you did not have ord.Amount wrapped in the aggregate SUM function.
It should work w/ the query listed.
It can't... there's no ORDER_ID column in the Vendor...
--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)

April 4, 2023 at 6:41 pm

#4169108
Reply To: reads for DMVs

You are correct. Each 7000 byte + the ID row occupies 1 page.
On my box, I'm always getting 2 reads more than the number of leaf level pages regardless 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)

April 4, 2023 at 6:30 pm

#4169099
Reply To: How to add couple more conditions to the query

It'll be interesting to see what kind of Execution Plan is built from all that. The use of DISTINCT also suggests that you may have at least 1 many-to-many return...
--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)

April 4, 2023 at 5:06 pm

#4169058
Reply To: simple query question
In the following, you have an underscore in the code that does not exist in the TBL_Vendor table.
```
on vnd.ORDER_ID = ord.ID
```
--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)
April 4, 2023 at 4:56 pm

#4169043
Reply To: Is TemporalTable SysStartTime available before performing an insert/Update?

Lordy. My apologies. I didn't look at the "record layout" for sys.dm_tran_active_transactions (from your query you posted)... The bloody database_transaction_begin_time column in that DMV is returned, by the system, as...
--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)

April 4, 2023 at 3:44 pm

#4169018
Reply To: Adding Multiple Columns

Steve Jones - SSC Editor wrote:
Thanks, ran into someone that didn't know you could do this in one statement.
That's the main reason I really liked the question. I've run into a whole lot 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)

April 3, 2023 at 2:42 pm

#4168514
Reply To: predictive query plan

Arsh wrote:
@Sridevi kakolu,
Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , 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)

April 3, 2023 at 2:07 pm

#4168498
Reply To: Living With Broken Software

Heh... Like I tell people, I don't hate computers... I hate the people that write the code and the people that don't test it properly.
And you don't even know if...
--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)

April 3, 2023 at 1:20 am

#4168229
Reply To: Adding Multiple Columns

Nice question, Steve!
--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)

April 3, 2023 at 1:14 am

#4168228
Reply To: predictive query plan

Like I said, glad to "meet" you.
The reference you provided is very helpful but it doesn't tell the OP how to find content like you did for the first thing...
--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)

April 3, 2023 at 12:06 am

#4168219
Reply To: Usage of #TempTables and an Index in Stored Procedure

Jonathan AC Roberts wrote:
Why does creating and inserting data into a table with insert into cause blocking but inserting into an existing table not cause blocking?
Someone like Paul White could answer 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)

April 2, 2023 at 9:32 pm

#4168204
Reply To: Significance of Historical waits report in SQL server Performance dashboard

The tran log I/O seems really high to me, as does query store. Without having more esoteric knowledge of the system, I'm hesitant to make any judgement on that.
I will...
--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)

April 2, 2023 at 7:40 pm

#4168191
Reply To: master.dbo.spt_values means?????????

Arthur Kirchner wrote:
I was shocked to learn that this table still exists in SQL Server, and nobody is talking about it ^^. It seems to be around since the 80s as...
--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)

April 2, 2023 at 6:00 pm

#4168179
Reply To: Usage of #TempTables and an Index in Stored Procedure

Nothing like shifting gears but, whatever. It's also not always the "better" way. "It Depends".
--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)

April 2, 2023 at 5:50 pm

#4168178
Reply To: predictive query plan

Ah... never mind... I found the source.
https://learn.microsoft.com/en-us/sql/relational-databases/performance/display-the-estimated-execution-plan
Consider telling the OP the search you did to find this documentation so that they may help themselves in the future. I believe it's...
--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)

April 2, 2023 at 1:48 pm

#4168145

Viewing 15 posts - 1,606 through 1,620 (of 59,067 total)