Forum Replies Created

Viewing 15 posts - 46 through 60 (of 129 total)

  • RE: Dynamic Where Clause in Reporting Services

    external (4/21/2009)


    I want to add to the conversation, if I may.

    The problem with the pattern "@XXX IS NULL OR XXX = @xxx" is that it ignores the indexes then.

    Best regards

    Andrew

    Why...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Deployment issue

    But when i'm trying to see that report in report manager manager through http://localhost/reports/Pages/Folder.aspx its not there.

    do you mean the report you deployed does not show? do you have any...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: What types of integrated security are available in reporting services?

    vishwajit.parab (4/21/2009)


    I know only about windows authentication...

    if know others please tell me

    Windows authentication with AD groups/users

    NO LDAP. you can create your own http://msdn.microsoft.com/en-us/library/ms152825.aspx

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: SSRS and Intranet

    Jack Corbett (4/15/2009)


    You can look into using the ReportViewer control.

    Thanks for this, not very helpful.

    I know there is a control and that I can use it. What I am looking...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Slow function in MSSQL2005 compared to MSSQL2000

    RBarryYoung (12/15/2008)


    Yeah, that's weird. I don't think that you should be able to do an EXEC in a function. You might want to try taking that out or...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Slow function in MSSQL2005 compared to MSSQL2000

    Jeffrey Williams (12/15/2008)


    Did you update statistics in 2005? Rebuild indexes? Update usage?

    And finally, not related to performance - but did you run DBCC CHECKDB db WITH data_purity?

    Will do...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Slow function in MSSQL2005 compared to MSSQL2000

    Lynn Pettis (12/15/2008)


    Not enough information. It would help to see the code, the DDL for the tables including defined indexes, and the execution plans for the queries.

    Interesting fact (before...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Maximum number of facts in star schema / SSAR cube??

    boxta (12/3/2008)


    Sorry.. not sure I understand exactly what you said... but did you mean it's much easier to do the SSAS population with 400 facts as columns??

    or did...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Maximum number of facts in star schema / SSAR cube??

    martin.lam (12/2/2008)


    hmm.. i thought about having a measurement dimensions.. but how would it impact creating measures in SSAS??

    Wouldn't SSAS automatically create the measures based on my fact table's columns? ...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: How to use same connection for number of packages

    m.bansal (12/1/2008)


    Hello,

    Thanks a lot.

    Can u plz tell me how can i use this configuration file or how to create this configuration. Please send me the link for more...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: how to get order month name in MDx Query

    Theres no way you can order something which has no sortable field (property) unless you hardcode the order.

    You must have an attribute in your time (month) dimension which is sortable.

    From...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Maximum number of facts in star schema / SSAR cube??

    Can't you have another dimension called METRICS or something like this so that you measure dimensions would have like one or two figures, rather than storing the whole lot in...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: BI DBA

    If it includes attempting to learn answers from a scripted set of questions prepared by someone else, then yes I'm dead against it. It serves little purpose for either interviewer...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: BI DBA

    Will Riley (10/7/2008)


    Why?

    If you have the knowledge your skills and abilities for the role will be obvious.

    If you don't, you have no business being in the job, as you will...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • RE: Cube Processing - Aggregations

    elegantkvc (10/3/2008)


    hi,

    Try the possibility of using perspectives in the cube.It will definetly speed up the cube processing.

    cheers

    vijay

    Thank you for the advice, but I would like to know WHAT exactly...

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

Viewing 15 posts - 46 through 60 (of 129 total)