Viewing 15 posts - 76 through 90 (of 2,267 total)
JamesMorrison (10/20/2011)
The pound is only $1.57 conversion rate. That means the upper end is only $63,000 per year?Is that correct? Are BI developers really paid that low in the UK?
It...
October 21, 2011 at 3:31 am
Have a look at the Kill function,
though be aware that this can sometimes take a long time to complete if there is a lot of work to undo.
October 21, 2011 at 2:54 am
what ever amount your company need really , generally i see places have up to two years detailed data and going back from there it is in summary form....
October 20, 2011 at 7:58 am
Dev @ +91 973 913 6683 (10/20/2011)
Agree with all this, however the optimizer will change a between to a => <=
This could be another topic of discussion. May...
October 20, 2011 at 3:20 am
how many rows are in your largest Fact tables?
also are you selecting data from a snow/star - flake schema?
October 20, 2011 at 3:05 am
Dev @ +91 973 913 6683 (10/20/2011)
•Do you need all columns data for your application? I guess not; so use specific columns in SELECT.
•For instance if you need only...
October 20, 2011 at 3:01 am
Yes it is a bad table design, not only the normalisation of it, but the fact that you have so many nvarchar and ntext columns.
Surely there is no need...
October 19, 2011 at 3:51 pm
that error usually occurs when you renamed a connection manager and not updated the compoenet that refered to it.
find which component is referencing it and click on it and change...
October 19, 2011 at 3:46 pm
can you include the data types?
from looking at the execution plan it seems that sql_post_date is not a date.time data typem is this correct?
you should ideally have a clustered...
October 19, 2011 at 3:43 pm
do you have a clustered index?
can you post the new execution plan?
also the table definition?
October 19, 2011 at 3:23 pm
I would check that the datatypes are the same as from the flat file, esp the BLOB data.
The script should throw an error if there is a problem in there.
you...
October 19, 2011 at 1:32 pm
try rerfreshing the view..
and check that are you connected to the same sever\instance that you installed it to
October 19, 2011 at 1:29 pm
I think it looks good and as long as you keep up with it and keep adding original content I am sure the traffic will pick up.
With regards to your...
October 19, 2011 at 12:47 pm
have you changed the data source that passes the data flow into this script?
October 19, 2011 at 12:25 pm
create a flat file connection, and then change format of this to be Fixed and then setup the col breaks in the columns tab.
October 19, 2011 at 7:45 am
Viewing 15 posts - 76 through 90 (of 2,267 total)