Viewing 15 posts - 5,686 through 5,700 (of 13,877 total)
Please help me to figure out why the SQL query is taking more time compare to ORACLE.?
Sounds like you figured it out for yourself. You're not comparing like with...
April 21, 2017 at 12:15 pm
SSIS packages do require an instance of SSIS to be able to run, unless SSDT has...
April 21, 2017 at 9:18 am
April 21, 2017 at 8:53 am
April 21, 2017 at 6:04 am
April 21, 2017 at 5:48 am
A more efficient way of coding this is to perform the deletion and then check @@ROWCOUNT afterwards, thus hitting the table once per deletion rather than twice.
April 21, 2017 at 5:45 am
Try running in 64 bit mode and see what happens.
April 20, 2017 at 3:50 pm
As SQL Server Express Edition does not support Integration Services, what do you expect SSDT...
April 20, 2017 at 11:59 am
As you already have a DMS, how is SQL Server involved in this?
April 20, 2017 at 10:03 am
Please post a screen shot of the screen where you have configured the parameter mappings.
April 20, 2017 at 9:58 am
April 20, 2017 at 7:59 am
'Forgiving' is not the word I would use, more like 'silently truncating data'. Here is some code to demonstrate the validity of Eirikur's suggestion.
SET ANSI_WARNINGS OFF;
IF...
April 20, 2017 at 7:37 am
shanegair - Thursday, April 20, 2017 7:14 AMSorry for the bad post, reading article now to get understanding of how to properly post.
I...
April 20, 2017 at 7:30 am
April 20, 2017 at 6:57 am
Thom, you should probably check this 🙂
April 20, 2017 at 6:56 am
Viewing 15 posts - 5,686 through 5,700 (of 13,877 total)