Viewing 15 posts - 16 through 30 (of 265 total)
I added the clustered indexes to the temp tables. the run time is close to 2.5 minutes. what! before the change the query was running in 20 seconds. what happened??
March 15, 2024 at 5:26 am
You need to remove the drop existing bit, as there is no existing index on a new table.
Thank you!
March 15, 2024 at 4:43 am
posting error
March 15, 2024 at 4:36 am
The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.
One of the big...
March 15, 2024 at 2:53 am
The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.
One of the big advantages of...
March 15, 2024 at 2:23 am
The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.
One of the big advantages of putting you...
March 15, 2024 at 12:10 am
The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.
One of the big advantages of putting you results into...
March 14, 2024 at 11:51 pm
For some reason, you didn't ask -- perhaps deliberately -- about the simplest and probably the best option, which is just:
SELECT field1,field2
FROM table1
Because there is no...
March 14, 2024 at 9:52 pm
thank you everyone!
I used the script that Jonathan provided. It turns out that temp was using float when I used numeric. Once I made this change the numbers...
March 14, 2024 at 7:20 pm
thank you everyone!
I used the script that Jonathan provided. It turns out that temp was using float when I used numeric. Once I made this change the numbers match.
March 14, 2024 at 5:35 pm
How many tables are updated during this process?
Does each table have date created / date modified columns?
Is the incoming data purely inserts, or inserts + updates, or inserts +...
March 12, 2024 at 3:15 pm
Just curious - but you stated you are using SSIS, but here you are using a stored procedure to execute a BULK INSERT?
I have to ask why you decided...
March 12, 2024 at 1:11 am
Does this work?
'INSERT INTO DBO.DataTable
SELECT *, NULL, ''N'' AS PROCESSED_FLAG
FROM #TEMP_TABLE'
it worked! thank you so much!
March 12, 2024 at 1:06 am
I assume the source file does not contain a processed_flag or processed_date column. I just ran a quick bulk insert test and when I added an extra column to...
March 11, 2024 at 4:53 pm
Viewing 15 posts - 16 through 30 (of 265 total)