Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 49,552 total)

  • RE: Rename instance from default (MSSQLSERVER) to named (e.g., DOCSHARE)

    The only way to rename an instance is to uninstall/reinstall.

    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

    January 17, 2017 at 5:09 am

    #1923147

  • RE: Size of sys.allocation_units.used_pages

    scarr030 - Monday, January 16, 2017 7:05 PM

    does more get allocated based on need?

    Yes.

    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

    January 17, 2017 at 2:55 am

    #1923136

  • RE: Index Related Question

    That code throws an error.
    Msg 4104, Level 16, State 1, Line 66
    The multi-part identifier "ic2.object_id" could not be bound.

    Can you post the working code that...

    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

    January 16, 2017 at 5:48 am

    #1922952

  • RE: Size of sys.allocation_units.used_pages

    Pages in SQL Server are 8KB.

    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

    January 16, 2017 at 2:52 am

    #1922916

  • RE: Index Related Question

    The script you posted works.

    Check the name you're putting in the WHERE clause, and check if your DB is case sensitive, if it is the case will matter...

    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

    January 16, 2017 at 2:51 am

    #1922914

  • RE: Filegroup for memory optimized tables and garbage collection

    N_Muller - Saturday, January 14, 2017 1:19 PM

    I'm new to memory-optimized (MO) tables.  I created a filestream filegroup and file for MO tables....

    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

    January 16, 2017 at 2:06 am

    #1922900

  • RE: 70-463 and 70-466 pre-requisit

    If the certification site doesn't list prereqs, then there aren't any.

    fwiw, MS exams don't tend to have pre-requisites, but the certifications require certain exams, so check which exams...

    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

    January 16, 2017 at 2:03 am

    #1922898

  • RE: Unique Indexing (case sensitive) ???

    Ed Wagner - Sunday, January 15, 2017 10:36 PM

    I've not tried this exact situation, but I think you'll be able to do what...

    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

    January 16, 2017 at 2:00 am

    #1922897

  • RE: 2014 vs 2016 ?

    Upgrade to SQL 2016, because Query Store
    and some other nice features including the availability of some previously Enterprise-only features in Standard and Express with SP1.

    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

    January 16, 2017 at 1:56 am

    #1922895

  • RE: Prevent Mass Updates With RowCount 1

    mary.clemons 79057 - Saturday, January 14, 2017 6:18 AM

    I have a mission critical table which at times unfortunately does need a manual update...

    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

    January 14, 2017 at 6:54 am

    #1922743

  • RE: SSC Forum Updates

    The 'word wrap' (or removal of) is doing some odd things to code.
    eg https://www.sqlservercentral.com/Forums/Topic1850494.aspx

    And having spaces lost like that makes it really tricky to reformat the code,...

    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

    January 13, 2017 at 7:57 am

    #1922568

  • RE: Why I am having error and how to solve this query

    You're missing a bracket after the GROUP BY in your subquery

    GROUP BY C.AccountNo, MONTH(T.CreatedOn), YEAR(T.CreatedOn) /*needs a close bracket here*/ B On A.CID=B.RefID

    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

    January 13, 2017 at 7:51 am

    #1922564

  • RE: Should this take hours?

    Are you creating the index directly on production during a time that the server is active? If so, the create will definitely take longer than it would otherwise.

    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

    January 13, 2017 at 5:35 am

    #1922527

  • RE: multiple small indexes or large covering

    whenriksen - Thursday, January 12, 2017 1:25 PM

    A very skinny index can read data faster, because more records fit per page.  However, every...

    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

    January 13, 2017 at 2:33 am

    #1922503

  • RE: SSC Forum Updates

    Jeff Moden - Thursday, January 12, 2017 8:54 AM

    Jeff Moden - Thursday, January 12, 2017 8:52 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

    January 12, 2017 at 10:03 am

    #1922372

Viewing 15 posts - 1,876 through 1,890 (of 49,552 total)