Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Tracing failed SP call

    Thanks! Just gave it a shot and I think it'll do.

  • RE: MDX 101 Question

    robinrai3 (5/14/2013)


    check this out :

    MEMBER MyValue as 'DimX].[DimId].currentmember.properties("value")'

    SELECT

    {[DimX].[DimId].Members, MyValue} ON ROWS,

    [Measures].[Mea_1] ON COLUMNS

    FROM MyCube

    also check out http://www.mdxsamples.com/ ...on why using properties is slow (see bottom para)

    Thanks...

  • RE: CmdExec Job Step just hangs

    They were confirmed for the SQL Server Agent user account.

    Problems been fixed and it turns out to have been permissions related all along, but with an unconvensional solution and obscured...

  • RE: CmdExec Job Step just hangs

    Thats the thing...I can manually run the robocopy statement directly in a cmd window and can run it via batch file. Both move the file(s) expected.. Soon...

  • RE: CmdExec Job Step just hangs

    Thanks for replying. Permissions have been confirmed, both share and NTFS.

  • RE: CmdExec - Jobs

    andriancruz (5/31/2010)


    Hi Everyone,

    I'm using CmdExec to call VB Application to extract records. The application is running fine. But when I put into Jobs the status is always executing. Anyone please...

  • RE: Help interpret SQLIO result

    Michael, are you able to assist on the above? thanks.

  • RE: Help interpret SQLIO result

    Michael Valentine Jones (4/19/2013)


    Your SQLIO test file size is far too small to be a valid test. I prefer to make it something close to the size of the...

  • RE: Help interpret SQLIO result

    This sounds good and is kinda what I've been doing. Do you know of any MS recommendation white papers that I can use to compare my latency results against...

  • RE: Help interpret SQLIO result

    DAS, RAID-5. Unfortunately, our server is installed an a virtual host. 32GB RAM allocated. I can't speak to what other hosts are sharing the same physical storage.

  • RE: Help interpret SQLIO result

    THanks for responding Andrew. Yes, I have. In fact I did that first. Yes, Avg Disk sec/Read is ~.030, which I believe is 30ms.

  • RE: Help interpret SQLIO result

    Can anyone provide any feedback on this or please point me in the right direction? Im not sure if I've given enough detail or if this is a question...

  • RE: How to execute SQL Agent Job Concurrently?

    I wanted to thank everyone for their replies. After some research, i've decided to implement an SSB solution. Thanks again for your help!

Viewing 13 posts - 1 through 13 (of 13 total)