Forum Replies Created

Viewing 15 posts - 271 through 285 (of 380 total)

  • RE: CTE

    Hugo Kornelis (10/22/2013)


    Joe Kelly-376311 (10/22/2013)


    What am I missing here ??

    Will "delete from ABC_CTE where id = 1;" not just delete the one record where id = 1 ??

    JK

    Yes, it will....

  • RE: Slowly Changing Facts

    jcraigue@cox.net (10/18/2013)


    A minor point, but not everything is a 'design pattern', nor does it need to be to be useful.

    Just trying to prevent more abuse of the language...

    Design Pattern has...

  • RE: Slowly Changing Facts

    sneumersky (10/18/2013)


    2. Allows for incremental processing of multidimensional Analysis Services cubes instead of an expensive full reprocessing of a cube.

    It is obvious you have been there and come back...

  • RE: Slowly Changing Facts

    psychodba (4/17/2012)


    I dont see any easy way to maintain AVG measures in this model. We need two layers of aggregations.

    SUM to construct the full amount and only then AVG. This...

  • RE: Slowly Changing Facts

    markoos1 - Great article. That is all 😉

    😎

  • RE: Slowly Changing Facts

    Rexell (12/13/2012)


    Can you let me know if you know of any other legitimate reasons for implementing this solution or of any other potential pitfalls you may have seen when implementing...

  • RE: Removing Duplicates

    Stefan Krzywicki (10/8/2013)

    It is funny, I agonized a bit over the example table. As I was putting in the columns I kept thinking "Well, if this were a real database...

  • RE: Removing Duplicates

    Jozef Moravcik (10/8/2013)


    Hi Guys,

    I see there is a wrong DB structure (table structure). Ussualy each master table should have at least a primary key. Using proper primary key you avoid...

  • RE: The Loss of Trust

    L' Eomot Inversé (9/7/2013)


    This is going to damage the US economy. Already people over here are recommending that no company should put any sensitive data into the cloud without...

  • RE: CTE

    Carlo Romagnano (9/25/2013)


    With complicated CTE, the optimizer does not choose the best plan.

    What is your source for this opinion about the optimizer?

    I would be good to share this information Carlo...

  • RE: Dynamic Query

    Interesting and easy question.

    The answer is only true because "--" creates comments only for the same line.

    The explanation is lacking in not pointing out the differences between using ...

  • RE: CTE

    John Mitchell-245523 (9/25/2013)


    paul s-306273 (9/25/2013)


    Can't see many people ever needing to use this feature.

    I've had developers gasp in wonder when I've shown them how to use code similar to Jamsheer's...

  • RE: Disable [guest] database user in [msdb] database

    Mike Dougherty-384281 (9/23/2013)


    I'm not sure that the _correct_ answer should always be "it depends" but the _kneejerk_ answer usually is.

    +10 to that! 😀

  • RE: Disable [guest] database user in [msdb] database

    Revenant (9/23/2013)


    Hmm... Got it wrong based on

    http://msdn.microsoft.com/en-us/library/ff648664.aspx

    which clearly recommends disabling the guest account (Step 4).

    This was also written in 2003 about SQL Server 2000 with .NET 2/VS 2003.

    For...

  • RE: Disable [guest] database user in [msdb] database

    Nice easy question for Monday Morning. Surprised that almost 50% have gotten it wrong so far. 😎

Viewing 15 posts - 271 through 285 (of 380 total)