Viewing 15 posts - 1,186 through 1,200 (of 11,676 total)
ps_vbdev (1/13/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2015 at 12:38 am
What is the original data type and what is the new data type?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2015 at 12:37 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2015 at 12:35 am
Jo Pattyn (1/12/2015)
Glad you keep the thread awake
Now that you are here: the mustard is excellent 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 12, 2015 at 12:12 pm
Very interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 11, 2015 at 8:25 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 11, 2015 at 8:24 am
Easy one, thanks Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 9, 2015 at 12:39 am
Viewing 15 posts - 1,186 through 1,200 (of 11,676 total)