Thank you both for your VERY, VERY helpful tips. Do you stornlgy reccommend Enterprise edition over the Standard for Analysis Services?
I am asking because I am being asked to justify the extra cost for both the database server and the SA Server.
Thank you,
Disha
Sorry - please accept my apologies on the license question - you do need separate license. Just verifying one point though - if I have a production server with 2 CPU Entrpeise Edition license then the Analysis Service License on a separate box will HAVE TO HAVE 2 CPU license for ENTERPRISE even...
U -
I am curious what helped you decide you needed to install Anlysis Services on a separate box from the database server? I am trying to decide if I need to do that too?
I can imagine - you get performance improvement right off the bat as you are not competing with the database.
Would you...
It may be that you need '" &...&"' around your string variables.
e.g. "update tblxyz Set abc = '" & .....&"'
If you are updating with a string.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.