Viewing 15 posts - 1 through 15 (of 580 total)
There's some info here: https://www.sqlservercentral.com/forums/topic/sp_prepexec-vs-stored-procedures
...and here: https://www.brentozar.com/archive/2018/03/sp_prepare-isnt-good-sp_executesql-performance/
January 25, 2021 at 1:48 pm
A former colleague of mine, who is much smarter than I am, once opined that people that do what we do should be in some way licensed, especially when working...
October 19, 2020 at 7:26 am
Have a look at the DMVs for SSAS. https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/
That should give you all you need.
September 16, 2020 at 7:57 am
Thanks Paul. The ASSP is a top 1 answer for this problem. However, I needed to do this with bare SQL. Which I managed.
On a side note, I...
June 11, 2020 at 6:20 am
Have you tried the ASSP project? Namely the DiscoverXMLMetaData function: https://asstoredprocedures.github.io/functions/DiscoverXmlMetadata/
Makes all of this easier.
June 10, 2020 at 12:15 pm
Good post - I have leveraged this for a while (this also works for deployment targets of SSRS/SSAS projects) but I'm always surprised more people don't use it. Nice one...
June 3, 2020 at 12:32 pm
SSIS Expressions are not T-SQL. Not only are there some things in your code that don't exist in SSIS expressions (CAST, CONVERT), where there are shared function names sometimes the...
May 14, 2020 at 11:29 am
Everyone is missing the most important barrier to home working. Tips on overcoming it can be found in this helpful guide: https://www.youtube.com/watch?v=IW3lhfVpLL4
March 16, 2020 at 12:17 pm
You would have to do some analysis of your data and determine where in the hierarchy, if at all, cost group should go. Bear in mind that users can always...
January 31, 2020 at 12:59 pm
You have to change the error configuration in the dimension properties to ignore key duplicates: https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/error-configuration-for-cube-partition-and-dimension-processing#bkmk_dupe
This can really mess up your query performance but if it's what the users...
January 31, 2020 at 12:20 pm
Because you are attempting to put Cost Group in a position in a relationship where it does not belong. The attribute relationships/keys are how SSAS determines what SQL to run...
January 31, 2020 at 11:35 am
Work out the cardinality of it vs the cardinality of the other attributes (taking into account composite keys and existing relationships) and then place it in the appropriate place in...
January 31, 2020 at 9:04 am
It very much depends on how you have each attribute set up (the key columns and the attribute relationships) but what you have to bear in mind is that when...
January 31, 2020 at 8:45 am
You don't mention whether you are using Tabular or Multidimensional - it's different in each case.
If it's multidimensional, based on what you are saying, the pattern would be 1. Process...
January 31, 2020 at 7:59 am
You have a few options, depending on how your cube is structured, but the most simple is to create a calculated column/named calculation (either in the underlying view/query or the...
January 31, 2020 at 7:42 am