water490

Forum Replies Created

Viewing 15 posts - 91 through 105 (of 367 total)

Reply To: how to force SS to run certain SP in parallel?

I think the issue is different so I am going to start a new thread

November 4, 2024 at 8:35 pm

#4477413
Reply To: how to force SS to run certain SP in parallel?

Jonathan AC Roberts wrote:
Here you are courtesy of ChatGPT:
Yes, it’s possible to run specific stored procedures (SP1 and SP2) in parallel and then have SP3 and SP4 execute in series within a...

November 4, 2024 at 7:10 pm

#4477392
Reply To: how to force SS to run certain SP in parallel?

I have two versions of SSIS setup to test the benefits of parallelism.
Version 1 - no parallelism setup. The precedence constraint I am using between the Execute SQL Tasks is...

November 4, 2024 at 7:07 pm

#4477391
Reply To: best choice for index when creating a composite key

thank you everyone for your feedback. i will implement as noted.

October 26, 2024 at 3:03 am

#4473916
Reply To: SSIS Question
deleted post
- This reply was modified 11 months ago by water490.
October 11, 2024 at 4:10 am

#4467481
Reply To: SSIS Question
deleted post
- This reply was modified 11 months ago by water490.
October 10, 2024 at 5:40 pm

#4467348
Reply To: SSIS Question
Jeffrey Williams wrote:
Yes - you definitely need to be using precedence constraints between tasks.
1. Reads (select) don't block other reads - locks on a select could prevent inserts/updates/deletes on the table(s)...
October 9, 2024 at 1:09 pm

#4466838
Reply To: SSIS Question
deleted post
- This reply was modified 11 months ago by water490.
October 9, 2024 at 1:09 pm

#4466837
Reply To: SSIS Question

Jeffrey Williams wrote:
water490 wrote:
Jeff Moden wrote:
First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values. Are you...

October 7, 2024 at 9:17 pm

#4466167
Reply To: SSIS Question
deleted post
- This reply was modified 11 months ago by water490.
October 6, 2024 at 3:23 am

#4465694
Reply To: SSIS Question
frederico_fonseca wrote:
google is your friend - you should have done it first.
https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16
regarding the code and because you got a timeout I would add a command timeout before the executenonquery.
```
This reply was modified 11 months ago by water490.
```

October 6, 2024 at 12:45 am

#4465674

Reply To: C# - how to convert string to date

Thank you so much!

April 24, 2024 at 1:09 am

#4414764

Reply To: need help with a SQL query

Jonathan AC Roberts wrote:

Not sure if this will be any faster, you might have to look at putting indexes on the table if it is not:

;with cte as
(
 ...

April 8, 2024 at 7:26 pm

#4408891

Reply To: need help with a SQL query

Jonathan AC Roberts wrote:

water490 wrote:

I think I fixed the issue. I added t_date to the partition part and now I am getting the correct number of records. The query is super slow...

April 7, 2024 at 7:54 pm

#4408538

Reply To: need help with a SQL query

I think I fixed the issue. I added t_date to the partition part and now I am getting the correct number of records. The query is super slow though. It...

April 6, 2024 at 4:44 am

#4408106

Viewing 15 posts - 91 through 105 (of 367 total)