Viewing 15 posts - 1,186 through 1,200 (of 11,678 total)
ps_vbdev (1/13/2015)
January 13, 2015 at 5:07 am
How I typically do this is that I keep a copy of the three source tables in a staging area. Meaning, I read from the source tables using CDC and...
January 13, 2015 at 4:58 am
My first thought is using an indexed view and putting CDC on that, but I'm not sure that is possible. I'm asking around if this is feasible.
January 13, 2015 at 4:46 am
khushbu (1/13/2015)
We are looking at any Third party tool since the code will eventually promote to Production environment where its...
January 13, 2015 at 1:35 am
khushbu (1/13/2015)
I can drop the index and recreate them however I do not want to the...
January 13, 2015 at 1:11 am
I don't immediately see issues with your plan.
Are there any views on the table?
The query plans for the stored procedures will most likely be recompiled on their next execution.
January 13, 2015 at 1:00 am
CDC needs to be enabled on the source database and on the individual tables. You then have the query some functions (created by CDC) to get the changed data.
If you...
January 13, 2015 at 12:45 am
You can also set TypeGuessRows to 0 in the registry. It then scans the first 60,000 rows or so.
January 13, 2015 at 12:43 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1650619-391-1.aspx
January 13, 2015 at 12:38 am
What is the original data type and what is the new data type?
January 13, 2015 at 12:37 am
Jo Pattyn (1/12/2015)
Glad you keep the thread awake
Now that you are here: the mustard is excellent 😉
January 12, 2015 at 12:12 pm
Very interesting question, thanks.
January 11, 2015 at 8:25 am
Viewing 15 posts - 1,186 through 1,200 (of 11,678 total)