Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 59,086 total)

Reply To: Looking for some guidance on avoiding Scalar UDFs for DB lookups

SteveOC wrote:
Hello Johan.
I have a couple of Scalar Functions that are sub-second.
1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by...
--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)

May 30, 2022 at 11:29 pm

#4041766
Reply To: How to Navigate through folders to find .zip file

Thanks for the feedback, Thom. I appreciate it.
--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)

May 30, 2022 at 2:19 pm

#4041607
Reply To: Iterate and reorganize subset of database tables

Also, if you need something "right away", they do have a previous presentation of mine on the subject. I have a couple of "mis-speaks" that I made during the "heat...
--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)

May 30, 2022 at 2:08 pm

#4041603
Reply To: Fill missing rows in dataset

So, just to be sure, "Component N" and "Region" can actually be anything, correct? And the goal is to assign the "N" of "Group N"? Do the requirements of "Group...
--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)

May 30, 2022 at 1:29 pm

#4041563
Reply To: Upgrading SQL Server 2008 R2 to 2017
Johan Bijnens wrote:
1. Always ( indeed ) start with Data Migration Assistant
2. Fresh Hardware / fresh OS / Latest SQL Server version and CU over in-place upgrades. Hands down. It...
--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)
May 30, 2022 at 1:17 pm

#4041558
Reply To: How to Navigate through folders to find .zip file

Thanks, Thom. It sounds like you've had some good experiences with SSIS.
A little bit off topic, if you good folks don't mind... I am curious about good experiences in SSIS...
--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)

May 30, 2022 at 1:15 pm

#4041557
Reply To: Looking for some guidance on avoiding Scalar UDFs for DB lookups

I'm thinking that I'm not understanding much either. 😀
You probably don't actually mean "Hierarchical"... you just mean you have some relational tables, correct? If that's the case, and ERD might...
--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)

May 30, 2022 at 3:30 am

#4041306
Reply To: Fill missing rows in dataset

Ombir wrote:
Let me give more context on this. I am trying to identify if multiple components have been purchased by customers (Sales>0) in Last 4 quarters and then on basis...
--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)

May 30, 2022 at 3:18 am

#4041303
Reply To: Parse txt file

Table looks right but I don't know why you resist providing the information I asked for. You didn't include the BULK INSERT I asked for. 🙁
No matter though. I 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)

May 29, 2022 at 6:01 am

#4040990
Reply To: why I cannot see memory related waits while server is under pressure?

See the following article and the link to the other article list in it.
https://blog.sqlauthority.com/2020/06/18/sql-server-queries-waiting-for-memory-grant-performance-tuning/
That will help you provide the proof you need to increase your RAM.

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

May 29, 2022 at 4:29 am

#4040970
Reply To: SSC "Points" ?

Steve Jones - SSC Editor wrote:
Various activities (post new topic, reply to one, post article, etc.). I think I need to file a bug that spam posts don't count as points.
It's worse than 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)

May 28, 2022 at 2:47 pm

#4040760
Reply To: Fill missing rows in dataset
@Ombir ,
I know that the Fill_Gaps table is just a test table here. What value is returned when you run the following code against the real table?
```
...
```
--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)
May 28, 2022 at 1:26 am

#4040526
Reply To: How to Navigate through folders to find .zip file

Doesn't SSIS allow you to run a CMD Task where you could issue the following simple DIR command and capture the output to a table? It'll give you the full...
--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)

May 27, 2022 at 11:06 pm

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

Thanks for the feedback Grant and Steve! I really appreciate it.

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

May 27, 2022 at 10:53 pm

#4040492
Reply To: Parse txt file

I don't know what the data is that you're playing that code against. Is strongly suspect that you may have imported the data incorrectly OR there's an anomaly in 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)

May 27, 2022 at 9:10 pm

#4040444

Viewing 15 posts - 3,421 through 3,435 (of 59,086 total)