Viewing 15 posts - 16 through 30 (of 36 total)
If you are using SAN storage, work with the SAN administrators to understand the hardware. How many disk controllers are there? Too many TempDb's can be just as bad as...
December 9, 2015 at 2:25 am
One possible solution that springs to mind is to use the Row_Number function in a CTE with parameters passed in for RowNumberFrom and RowNumberTo and your output SQL using these...
September 25, 2015 at 7:19 am
I use a VB.net script task to set the date:
Dts.Variables("BatchDate").Value = date.Now()
May 6, 2015 at 2:18 am
I was on a training course a few months ago with Dejan Sarka as the lecturer. It was his opinion that RDMS is here to stay and there is a...
May 5, 2015 at 7:07 am
This is still happening, but is being caused by me leaving the project open on my PC overnight. If I save everything, close and re-open the solution then everything is...
May 5, 2015 at 6:48 am
It sounds like a view has SCHEMABINDING set. In the article properties is it set to Drop or Truncate the table at the Subscriber? Truncate should work but Drop will...
April 27, 2015 at 4:51 am
I didn't think about it being a compatibility problem, you have hit the nail on the head. We are replicating from 2012 to 2008.
Thank you for taking the time to...
April 13, 2015 at 2:18 am
I am using a 64 bit environment with debugging set to 64 bit. However many of the IDE tools will only work in 32 bit mode at runtime in the...
November 5, 2014 at 5:35 am
I had an issue similar to this, but in SQL Server. I had a calculated field in a table. If I used SELECT * in a query the field values...
November 4, 2014 at 4:50 am
Hi Lemster.
Talking this trough has been very helpful, you have affirmed my understanding of how replication works. As you say we could just leave the log reader running.
If I have...
January 17, 2014 at 4:56 am
Hi Lemster.
You are correct in that the Distributor handles the feed to he subscribers. I think I wasn't clear in my explantion.
The point I was trying to make is the...
January 16, 2014 at 10:02 am
Thank's Lemster.
All of the transactions this db receive are at set times. My way of thinking is that while the log is being written to on the Publisher, to decativate...
January 16, 2014 at 9:24 am
Hi.
As an update, here is the code I am trying to run in the script component. I have made the inputs of Address1 and Address2 ReadWrite
Public Overrides Sub Input0_ProcessInputRow(ByVal Row...
September 7, 2010 at 10:41 am
If your table has indexes on it modify the package to drop the indexes, then import the data, then create the indexes.
November 6, 2009 at 9:51 am
John Rowan (11/5/2009)
Yes, you can...
November 6, 2009 at 9:46 am
Viewing 15 posts - 16 through 30 (of 36 total)