Thx for the input. The reason I asked was we have a db (which we use to store small images) that has grown to 1.5 gig. But there really is not enough data to account for this size.
I copied this db to my test env and ->
Deleted the data out of almost every table (except for seed data) and...
If you do the restore on the same server -
Make sure you restore the Log and Data file under a differnet name (then your source db files that is). You can access this info under the options tab of the restore window.
thx
Hello,
Does anyone know how SQL Server stores an Image data type.
Meaning ->
If my images are around 2k and the image field max is 500k, will this small image take up only 2k of space or would it use the entire 500k?
thx for you help.
Hello.
Does anyone know if its possible to name subtotals dynamically.
That is - I have Sub Totals specified on a report at the Division Level.
This Sub-Total's header/label currently displays as "Total for Division"
Is it possible to dynamically insert the attribute value so that...
Thanks for the input nlim.
Thats exactly what I was looking at. The underlying reports are running slow.
The report SQL shows multiple passes. Anyway I've identified the issue a little better and just posted a new thread - Thanks.
Aman
Also, we had another report with the same situation. Its sql execution time was 7 seconds. After using a fact in the metric instead, sql execution was improved to 3 seconds.
Thanks,
Aman
One of our reports has been running extremely slow. Taking almost 5 minutes for 32 rows
By removing one of the metrics on the report, the execution time improved dramatically from 5 minutes to 45 seconds!
The metric I removed was just a count on an Attribute (Employee ID).
So, I created a...
Hello,
Does anyone have extensive experience with MS Document objects?
Currently we have Document objects with reports embedded in them. Some document objects contain multiple reports others only have a one embedded in them.
Regardless of how many reports are embedded, executing these...
Hello.
We need to set up a new MicroStrategy env.
This new environment will be based on our QA test env.
I plan on duplicating our QA project to this new environment.
However, one report in QA(a complex one) has not been fully tested so we dont want to bring it over yet to the new env...
Go under object manager -> Tools ->
Object Manager Preferences
Select the tab for Conflict Resolution - Near the bottom right you'll see a button 'Set Default Actions'.
Is this what you were looking for?
Thanks mstrNate. (for input on the migration as well)
Fortunately we do have access to the MS Knowledge base and tech support. Even then it seems like something always comes up.
Hello,
Does anyone know of any other MicroStrategy resources available?
I've found tek-tips extremely helpful, but are there any other good user groups available?
Thanks
Thanks you every one for your input it has proved useful. I've only been using MS for about 3 months. Been challenging and this is the only user group I've found.
Well, back to the migration topic….
Currently we've got the following environment set up:
Dev, QA, UAT, Prod. All object migrate...
Hello,
We are currently using 7.2.2
We are tyring to create an efficient method/protocol to migrate MS objects from Development to QA and then to Production.
Some of our concerns:
Dev envronnment has a lot of objects that are not ready for migration to QA. (Like wise for QA migrations to...
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.