Viewing 15 posts - 4,456 through 4,470 (of 59,067 total)
Just to add to that, I NEVER bulk insert directly into the final table. I ALWAYS load into a "staging" table and then do validations and dupe checks between that...
October 15, 2021 at 4:16 pm
My recommendation would be to read the documentation for BULK INSERT, which is located at the following URL:
https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-ver15
The two keywords to search for in that article are ERRORFILE and...
October 15, 2021 at 4:11 pm
A trigger is the perfect approach for this. Some developers just irrationally avoid triggers no matter what.
Be sure to specify option FIRE_TRIGGERS in your BULK INSERT command.
[Edit] My...
October 15, 2021 at 4:06 pm
If you filter on step_id = 0, you'll get the info for the entire job instead of the final step.
October 15, 2021 at 2:26 pm
Have you thought about how many rows are in the table to begin with? If 35m and you're deleting 30m, maybe a faster approach, to
begin with, is to insert...
October 15, 2021 at 2:14 pm
If you're calling a scalar function, it's RBAR.
October 15, 2021 at 1:03 am
And yet, I've not seen where that actually matters. And, it won't matter unless you're doing RBAR updates of the same row more than once every 3.3 milliseconds because the...
October 14, 2021 at 4:02 am
If it's a connection pool, then you'll know the benefit... faster connections for your users.
If it's a connection leak, you'll eventually run out of connections.
The disadvantage is that each connection...
October 12, 2021 at 2:26 pm
Are you sure it's not just a connection pool of some sort? Killing such spids could cause a bit of slowdown.
The opposite of that beneficial thing is that it could...
October 12, 2021 at 1:12 pm
Your research idea needs to be fresh, relevant, and interesting. Read as much as you can on your topic. Look at textbooks, read journal articles, watch relevant documentaries, and...
October 12, 2021 at 12:59 pm
Hi,
I am looking to create a case statement that gets different quantities. For example, I would like to see how many orders were created between 6pm yesterday till 6pm...
October 12, 2021 at 5:45 am
Hi Zidar,
Here's the create table code and attached is a sample output. Hopefully this helps!
CREATE TABLE [dbo].[FactBP](
[CREATE_DATE] [date] NULL,
[CREATE_TIME] [varchar](8) NULL,
[ADJ_REQ_SHIP] [datetime] NULL,
[RELEASED_DATE] [date] NULL,
[RELEASED_TIME] [varchar](8)...
October 12, 2021 at 5:31 am
you now do groupings based on the timeslot name. No proprietary computations. Fast, simple joins. The ability to adjust your timeslots in the event of banking holidays.
Cool! Got...
October 12, 2021 at 3:34 am
The only reason I can see for doing such a thing is to have all the files since the last backup in one file especially for when it comes to ...
October 12, 2021 at 2:40 am
One of the best ways to find subjects to write about is to let them find you. You will have to start reading the best source in the world for...
October 11, 2021 at 7:19 pm
Viewing 15 posts - 4,456 through 4,470 (of 59,067 total)