Forum Replies Created

Viewing 15 posts - 61 through 75 (of 727 total)

  • RE: Analysis Services Multidimensional

    Good question. 🙂

  • RE: Valentines Day

    Stewart "Arturius" Campbell (2/14/2014)


    twin.devil (2/14/2014)


    now who said sql server does not have a heart 😛

    +1 :laugh:

    +10 😛

  • RE: Query help

    ScottPletcher (2/13/2014)


    If the function just removes an optional trailing '-' followed by other chars, you can avoid a function completely using CROSS APPLY:

    UPDATE ts

    SET

    Col1 = CASE...

  • RE: Query help

    What i'm looking for is any update like this:

    UPDATE tbl_source

    SET Col1 = CASE WHEN LEN(dbo.fn_ConvertToNumeric(col3)) > 10 AND dbo.fn_ConvertToNumeric(col3) LIKE '111%' THEN SUBSTRING(dbo.fn_ConvertToNumeric(col3), 4, LEN(dbo.fn_ConvertToNumeric(col3)) ELSE dbo.fn_ConvertToNumeric(col3) END

    WHERE col2...

  • RE: Query help

    This is simplest one and i tried it by my own. It will not consider the values like

    col3 = 11123456789-xyz

    In this case it should be 23456789

  • RE: Slow insert into a table

    Nope there are no cursors used. But I can see the execution plan for the table. And it shows almost 75% of the time taken for Insertion operation.

    Attached is the...

  • RE: Analysis Services Multidimensional

    Hany Helmy (2/6/2014)


    Carlo Romagnano (2/2/2014)


    I also found this doc from MSDN that explains the answer

    SSAS2005PerfGuide.doc

    +1

    +1

    I have practiced on some basic SSAS and this is new territory for me. So giving...

  • RE: Execution Plans

    Very good question. Something which developers need on day to day basis. 🙂

  • RE: Compression

    I have never checked it but logically seems to go thatw ay only.

  • RE: SQL Server Health and History Tool

    I was totally unaware of this tool. Thanks for this question dude,.

    . 🙂

  • RE: SSRS 2008 reporting issue

    This is done. There were some more records added at the far end which were taken into consideration based on order by clause.

  • RE: value() Method (xml Data Type)

    Very interesting question. 🙂

  • RE: SSAS: Tabular vs Multi Dimensional

    Had to search for it but good to know about. 🙂

  • RE: IDENTITY RESEED

    Very good QOTD. The answer here clarifies few thigns about the identity functionality in simplest way. Thanks Lokesh. 🙂

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    It was a very good question. The first two were simple but the third one was tricky. 🙂

Viewing 15 posts - 61 through 75 (of 727 total)