Forum Replies Created

Viewing 15 posts - 601 through 615 (of 49,552 total)

  • RE: "convert" tables to cluster columnstore indexes

    Script the indexes, then drop them and the clustered index and create the clustered columnstore

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 24, 2017 at 8:49 am

    #1969404

  • RE: Column Length

    Arsh - Thursday, November 23, 2017 6:55 AM

    Is this the same way SQL works in current versions , I mean beyond...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 23, 2017 at 7:28 am

    #1969344

  • RE: Revert the data compression on the SQL database

    If you have a backup of the DB before you removed the compression, you can restore that somewhere and check what indexes were compressed and what compression they had.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 23, 2017 at 1:00 am

    #1969321

  • RE: why query optimizer is using Non-clustered index for count(*) operation

    Because a count(*) is asking how many rows are in the table, not the contents of the rows, and hence that can be answered with any index, as all non-filtered...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 22, 2017 at 12:39 am

    #1969120

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Tuesday, November 21, 2017 10:57 AM

    GilaMonster - Tuesday, November 21, 2017 10:23 AM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 2:05 pm

    #1969092

  • RE: Are the posted questions getting worse?

    Ed Wagner - Tuesday, November 21, 2017 5:34 AM

     why tempdb shows up later - I'm thinking it depends on how long...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 10:23 am

    #1969045

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Tuesday, November 21, 2017 8:13 AM

     I'd really be interested in seeing that because it seems contrary to the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 10:20 am

    #1969042

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Lynn Pettis - Tuesday, November 21, 2017 8:58 AM

    Actually, I don't think it occurs on startup as much as on shutdown.
    I just...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 10:09 am

    #1969037

  • RE: Why SQL Server is not using non-clustered index

    Maybe. Depends on the predicate, the index key columns and the rest of the query. It's not as simple as you're making out.
    There's a lot of posts on indexes...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 3:47 am

    #1968966

  • RE: Why SQL Server is not using non-clustered index

    It's going to have to scan something, since there's no filter on that query. Optimiser calculated that a scan of the table will be the most efficient.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 21, 2017 at 3:22 am

    #1968964

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Monday, November 20, 2017 2:49 PM

    GilaMonster - Monday, November 20, 2017 2:02 PM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 20, 2017 at 11:54 pm

    #1968951

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Monday, November 20, 2017 8:34 PM

    From the looks of it, master started and then just about everything else started...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 20, 2017 at 11:53 pm

    #1968950

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Monday, November 20, 2017 1:20 PM

    Thom A - Monday, November 20, 2017 12:11 PM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 20, 2017 at 2:02 pm

    #1968888

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Eirikur Eiriksson - Monday, November 20, 2017 10:30 AM

    Monitoring the I/O, normally more is happening on the tempdb side but since...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 20, 2017 at 2:01 pm

    #1968887

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    Jeff Moden - Monday, November 20, 2017 10:10 AM

    GilaMonster - Monday, November 20, 2017 4:33 AM

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    November 20, 2017 at 1:58 pm

    #1968886

Viewing 15 posts - 601 through 615 (of 49,552 total)