Hi Lynn Pettis,

So great of you, firstly thanks a lot for the commitment you are showing to help out others in this community.

There were just two many dependencies within the...

Hi Siva,

Select the header in the design area and then have look at the properties, at the bottom you will find other and in that you will find the repeat...

Hi All,

In the other properties, you have this Repeat With Property and in that you have to choose a table name from the report and thats it... 🙂

Regards,

Sriram

Hello brother,

think you have some data issue around or there can be issues with the system as such, in the analysis service processing task, put setting for capturing the log...

Did not fine the jdbc suitable, there were couple of drivers available like olap4j... but was not able to make them work 🙁

so did a workaround, connected to sql...

I think you can download the basic management studion, generate script and then dump the data using insert into queries.

never used it, it will be easier if you have...

found something... I cant say its good ...but..okay http://www.codebydesign.com/SystemArchitect/downloads/

The script shown is really nice, rather the author has shown a generic approach on how we can build tools to make our lives easier!!!

Nice script, keep posting. 🙂

Regards,

Sriram

Hi...Actually wanted to know the kind of improvement in numbers/ %ge if we move sql db to a solid state drive...

I know that we can move it but it is...

any stats about the server, or about the database size. Beucase I just have a 10GB database and want to give a try.

Hi,

Instead try appending the vairables in a string and use it with sp_Executesql.

Regards,

Sriram

We cannot directly call a stored procedure like that in a select statement, if possible try converting the proc to a function and use it.

Or

If youur main select query...

Yes, the answer could have been that also, but for in the question we have (clustered + non clustered) explicitly mentioned.

Thanks for all the people who say the question is interesting, and also thanks to all those people who have pointed out the short comings in the question.

Expected READ_COMMITTED_SNAPSHOT to be set to OFF, thought will remain default atleast for test db's ...