Forum Replies Created

Viewing 15 posts - 286 through 300 (of 3,348 total)

  • RE: Bitwise & NULL

    Sioban Krzywicki (12/13/2016)

    I want to use a bitwise column because there may be more columns added in the future. With a bitwise column, you just add a new value. With...

    December 13, 2016 at 10:42 am

    #1917691

  • RE: Stairway to Columnstore Indexes Level 9: Batch Mode Execution

    choiclark (12/9/2016)

    Hi Hugo,

    Thanks for the article.

    I went ahead and ran the code in Listing 9-3 on SQL Server 2012 instance, and checked the execution plan with and without the optimizer,...

    December 10, 2016 at 8:34 am

    #1917191

  • RE: Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

    choiclark (12/8/2016)

    Hello Hugo,

    Thanks for this article.

    I am a bit confused by your explanation along with Listing 6-8 and Figure 6-5 because it looks like "Rowgroup 2" and "Segment 2" seem...

    December 10, 2016 at 7:59 am

    #1917190

  • RE: Number of logical reads very different between 2 supposed identical environments

    polytropic2310 (11/28/2016)

    From my understanding of your explainations, optimizer uses kind of internal indexes based on statistics

    That's a misunderstanding. SQL Server doesn't have any internal indexes. If you do not create...

    November 29, 2016 at 1:23 am

    #1914875

  • RE: Number of logical reads very different between 2 supposed identical environments

    polytropic2310 (11/23/2016)

    Hello Hugo,

    Hugo Kornelis (11/23/2016)

    Well, I can tell with 100% certainty that there are at least two differences:

    1. The statistics on the data in UAT are different from those on...

    November 24, 2016 at 6:09 am

    #1914405

  • RE: Number of logical reads very different between 2 supposed identical environments

    polytropic2310 (11/23/2016)

    I'm sure at 99.99% that the content of tables/views is the same.

    Well, I can tell with 100% certainty that there are at least two differences:

    1. The statistics on the...

    November 23, 2016 at 10:48 am

    #1914289

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/23/2016)

    Luis Cazares (11/23/2016)

    Steve Jones - SSC Editor (11/23/2016)

    robert.sterbal 56890 (11/23/2016)

    What is on your menu for Thanksgiving?

    Can you share any recipes?

    Our family will be having Thanksgiving...

    November 23, 2016 at 10:38 am

    #1914286

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/22/2016)

    They always come in threes don't they, we have rodiots (road idiots), phoniots (idiots with phones) and now planiots (execution plan idiots)

    😎

    Hmmm, that is a very interesting. I...

    November 22, 2016 at 1:39 pm

    #1914118

  • RE: Number of logical reads very different between 2 supposed identical environments

    Looking at the plan, this appears to be an example of what is actually a very common problem.

    The pattern in the execution plan that causes this is basically:

    (Top) <===...

    November 22, 2016 at 1:34 pm

    #1914116

  • RE: Are the posted questions getting worse?

    WayneS (11/21/2016)

    Hugo Kornelis (11/17/2016)

    Luis Cazares (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Eirikur Eiriksson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER...

    November 22, 2016 at 4:59 am

    #1913945

  • RE: Today's Random Word!

    Brandie Tarvin (11/22/2016)

    Ed Wagner (11/21/2016)

    Manic Star (11/21/2016)

    Grumpy DBA (11/21/2016)

    Luis Cazares (11/21/2016)

    djj (11/21/2016)

    High

    Mile

    Club

    Sandwhich

    Sub

    Station

    Train

    November 22, 2016 at 4:56 am

    #1913943

  • RE: Today's Random Word!

    DamianC (11/18/2016)

    Stuart Davies (11/18/2016)

    Revenant (11/17/2016)

    Ray K (11/17/2016)

    djj (11/17/2016)

    Ed Wagner (11/17/2016)

    Luis Cazares (11/17/2016)

    Ed Wagner (11/17/2016)

    whereisSQL? (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Luis Cazares (11/17/2016)

    crookj (11/17/2016)

    TomThomson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    crookj (11/17/2016)

    Grumpy DBA (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Ed Wagner (11/17/2016)

    Acronym

    Synonym

    Cinnamon

    Stick

    Ball

    bat

    Batgirl

    Robin

    Round

    Square

    Deal

    Breaker

    Ice

    Water

    Fire

    Bird

    nest

    soup

    of...

    November 18, 2016 at 2:16 am

    #1913346

  • RE: Today's Random Word!

    Luis Cazares (11/17/2016)

    crookj (11/17/2016)

    TomThomson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    crookj (11/17/2016)

    Grumpy DBA (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Ed Wagner (11/17/2016)

    Acronym

    Synonym

    Cinnamon

    Stick

    Ball

    bat

    Batgirl

    Robin

    Round

    November 17, 2016 at 9:40 am

    #1913139

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Eirikur Eiriksson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it...

    November 17, 2016 at 8:28 am

    #1913108

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and...

    November 17, 2016 at 7:47 am

    #1913083

Viewing 15 posts - 286 through 300 (of 3,348 total)