Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 59,091 total)

Reply To: Are the posted questions getting worse?

Nope... not missing those points at all. Those are the points that I'm actually afraid of because the folks that need to use it are going to believe its "correct"...
--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)

February 9, 2023 at 3:25 pm

#4147598
Reply To: Return a set of rows between 2 values (multiple times)

Thom A wrote:
If that's the case, the OP could make use of GENERATE_SERIES as (based on your recent findings, Jeff), it's performant for a single series, which the OP seems 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)

February 9, 2023 at 3:14 pm

#4147596
Reply To: Nesting Cursors

And, wow... Phil Carter. Were did you ever get off 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)

February 9, 2023 at 3:06 pm

#4147594
Reply To: Update records using previous row and calculated value of current row.

Look into LAG.
https://learn.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver16
You could also do a "rolling average" using AVG() OVER but it would likely be much more expensive to do it that way.

--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)

February 9, 2023 at 3:03 pm

#4147591
Reply To: Nesting Cursors

Ok... since SPAM keeps necroing this 2 decade old thread and someone might read it and without knowing what the cursors are actually being used for, I'll just up 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)

February 9, 2023 at 3:00 pm

#4147580
Reply To: Return a set of rows between 2 values (multiple times)

Thom A wrote:
So where do these linked integers come from? Why, for example, is 1 linked to 1, 2, and 3, but the numbers 8 to 14 only linked to 8?
Apparently,...
--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)

February 9, 2023 at 2:54 pm

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

Michael L John wrote:
SSC pulls thru again!
{snip}
Guess who whipped this baby into shape in about 2 days?
Someone who's an obvious and valued resident of the SSC Sanitorium in the DBA Disneyland...
--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)

February 9, 2023 at 2:37 pm

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

Brandie Tarvin wrote:
Talking about ChatGPT, has anyone seen this one yet? https://www.cnn.com/2023/02/08/tech/google-ai-bard-demo-error/index.html
<headdesk>
Yes... and they're making an big deal about it. ChatGPT is constantly providing incorrect answers about code and people 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)

February 9, 2023 at 2:32 pm

#4147563
Reply To: how to make a col in a table after checking its existence, in one stmt

The time you're seeing in that image is the time it took to actually make the column change. Try making the actual column change with the INFORMATION_SCHEMA method and see...
--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)

February 9, 2023 at 2:12 pm

#4147549
Reply To: Select values from second table that are not linked to first table
As a bit of a sidebar, this uses 31% fewer reads, which will come in handy for when the cross joined tables are larger...
```
 WITH 
 cteProduct...
```
--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)
February 9, 2023 at 6:22 am

#4147386
Reply To: Select values from second table that are not linked to first table

Never mind... post deleted because it wasn't necessary. The OP figured it out.
--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)

February 9, 2023 at 5:43 am

#4147366
Reply To: how to make a col in a table after checking its existence, in one stmt

rajemessage 14195 wrote:
i think information schema is better because col_length is a function call and finally it would go to sys.objects or all_objects or information schema it self.
This is what I...
--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)

February 9, 2023 at 4:55 am

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

Got the first post on a page again... and again, it's not showing up until another post (this one) is made.
--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)

February 9, 2023 at 4:14 am

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

According to Paul White (and what I heard early on when they first started meta-caching of Temp Tables), dropping the tables does NOT prevent caching of Temp Table meta-data.
https://sqlperformance.com/2017/05/sql-performance/sql-server-temporary-object-caching
--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)

February 9, 2023 at 4:13 am

#4147343
Reply To: blocking issue

Grant Fritchey wrote:
Ha! I may have overly played up the "scary" part of the scarydba occasionally.
I apologize. I didn't intend to embarrass, my dear ol' friend.
--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)

February 9, 2023 at 4:01 am

#4147341

Viewing 15 posts - 1,981 through 1,995 (of 59,091 total)