Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 59,098 total)

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
Reply To: Iterate and reorganize subset of database tables

ktflash wrote:
frederico_fonseca wrote:
I'll let Jeff do some chopping but WHY Reorganize? this should be avoided almost at all costs (very few exceptions)
Not aware of that, also can't seem to find...
--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 4:19 pm

#4040318
Reply To: Starting on Monday

As a bit of a sidebar... I have a visceral hate for DATEFIRST() and @@DATFIRST(). It just bugs me.
With that, and even though it's a tiny bit slower, I 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)

May 27, 2022 at 7:31 am

#4040108
Reply To: Starting on Monday

Actually, none of the answers are correct (and I didn't click an answer because of that... they're all incorrect).
The first answer is syntactically incorrect because DATEPART only takes two operands.
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 6:51 am

#4040082

Viewing 15 posts - 3,436 through 3,450 (of 59,098 total)