Viewing 15 posts - 46 through 60 (of 485 total)
In the function what data types are used for the two parameters passed?
In the procedure are the datatypes used for @Network_ID, @Target_Date the same types as used in...
November 3, 2016 at 8:15 am
Persoannly I would avoid using triggers, here is some alternative options.
How up to date does your summary table need to be? I.e. real time, or can be minutes \...
October 25, 2016 at 9:24 am
If you set this up as a SQL Agent job as Jeff mentioned should give you what you want providing you have dbmail setup on your SQL server:
--Create a temp...
October 5, 2016 at 3:10 am
Another option if the source tables are indeed split over tables on separate databases is to publish the tables and in the article properties only include the columns you need...
September 30, 2016 at 10:03 am
edited for accuracy.
homebrew01 (9/30/2016)
RTaylor2208 (9/30/2016)
When replicating an indexed...
September 30, 2016 at 9:30 am
How about combine all your data at the source and then replicate it to the subscriber using an indexed view as an alternative?
When replicating an indexed view it will be...
September 30, 2016 at 4:40 am
We have had the exact same issue on a few VM's here. Our VM guys have a fix for it, I'll see if I can get the answer for...
September 21, 2016 at 7:51 am
Using only the CLI this is pretty difficult to do, but using the AWS python SDK or powershell its much easier. Here is one way to do it...
September 8, 2016 at 4:07 am
AWS itself is a huge subject, but if your specifically looking at running SQL Server on AWS you really have two options:
1. RDS - A cut down version of...
September 8, 2016 at 3:32 am
I too work in a fairly small city, Glasgow, Scotland < 1M people even if you include a lot of the surrounding areas. Salaries offered are all over the...
September 7, 2016 at 4:55 am
After such a long time away from working with SQL Server I'd say tackling an exam per month is ambitious at best. 461, 462 and 463 there are Microsoft...
July 18, 2016 at 5:07 am
Using BDD its slightly better perfromance, going on the processing rate it will take 9.4hours to complete compared to 23 hours when running a normal data flow.
Its a bit...
July 5, 2016 at 2:35 am
twin.devil (7/5/2016)
Have you check your MySQL Settings if then Please check the following link.
Yes, I have checked mysql we do not use the MyISAM storage format, all tables are innodb.
Keep...
July 5, 2016 at 2:04 am
prvmine (7/4/2016)
have you tried using the “Balanced Data Distributor” for SSIS?https://blogs.msdn.microsoft.com/sqlperf/2011/05/25/the-balanced-data-distributor-for-ssis/
the balanced data distributor works with ADO.net connections
usually with MultipeActiveResultSets and increased packet size
Thank you for the suggestion, I...
July 5, 2016 at 2:01 am
OLE DB Sources \ Destinations are not valid for MySQL as no OLE Provider exists for MySQL.
I have also tried adjusting the batch sizes both for the data flow container...
July 4, 2016 at 8:07 am
Viewing 15 posts - 46 through 60 (of 485 total)