Forum Replies Created

Viewing 15 posts - 1,696 through 1,710 (of 49,552 total)

  • RE: Please explain difference between these terms

    larsp777se - Monday, March 6, 2017 4:54 AM

    Can you say that a login can be assigned to a Server role and a...

    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

    March 6, 2017 at 5:47 am

    #1931766

  • RE: checkdb "Multiple IAM pages for object"

    What's the full, unedited output of
    DBCC CheckDB WITH NO_INFOMSGS;

    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

    March 6, 2017 at 5:43 am

    #1931765

  • RE: T-LOG FOR AOAG

    AGs do not use log backups, but you still need to take them (databases are in full recovery) and you do want to keep them around for DR.

    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

    March 6, 2017 at 4:10 am

    #1931758

  • RE: The Accidental DBA - Wait Stats

    I think they are all cumulative.

    They are. Cumulative since SQL started (most people don't clear wait stats).

    Can you get permission to add a...

    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

    March 6, 2017 at 3:56 am

    #1931756

  • RE: Newbie help please!

    Please don't post multiple threads for the same problem. Answered at https://www.sqlservercentral.com/Forums/1862776/Help-please-total-newbie-trying-to-learn-Trying-to-Change-the-first-character-in-a-field

    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

    March 6, 2017 at 3:33 am

    #1931749

  • RE: The Accidental DBA - Wait Stats

    John Mitchell-245523 - Monday, March 6, 2017 3:25 AM

    Yes, the advice from the previous DBA is good.

    Yup, although since 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

    March 6, 2017 at 3:28 am

    #1931747

  • RE: The Accidental DBA - Wait Stats

    I don't like looking at percentage waits, and imo, waits aggregated over more than an hour are useless, I can't tell what might have caused them.

    Create a job...

    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

    March 6, 2017 at 3:26 am

    #1931746

  • RE: How to choose between Clustered Columnstore & Non-Clustered Columnstore index

    SN, I'm not all that clued up on columnstore indexes (yet), what I read recently is that clustered columnstores are mostly for analytics systems (OLAP-style), while nonclustered columnstore indexes are...

    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

    March 6, 2017 at 1:48 am

    #1931735

  • RE: How to choose between Clustered Columnstore & Non-Clustered Columnstore index

    JasonClark - Monday, March 6, 2017 1:40 AM

    please have a look on here: http://www.sqlserverlogexplorer.com/overview-of-cluster-and-noncluster-index/

    The question was about clustered and nonclustered *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

    March 6, 2017 at 1:45 am

    #1931734

  • RE: All Columns as Included

    The write speed is probably the least of the problems (unless you've got 10+ indexes). You've just duplicated that table, meaning it's taking up twice the space, twice the memory,...

    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

    March 5, 2017 at 12:10 pm

    #1931710

  • RE: Format Date but Keep as Date Type

    A date, by definition, has no format because it's stored internally as numbers. Format is something specific to the string representation of a date.
    In short, you can't. If you...

    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

    March 5, 2017 at 11:59 am

    #1931706

  • RE: Please explain difference between these terms

    larsp777se - Sunday, March 5, 2017 6:45 AM

    However, you still need to be added as a user to a database to be...

    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

    March 5, 2017 at 11:47 am

    #1931705

  • RE: Please explain difference between these terms

    larsp777se - Sunday, March 5, 2017 7:02 AM

    If I am added to the role doctor, I can login as doctor with all...

    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

    March 5, 2017 at 11:42 am

    #1931704

  • RE: Unrecognized SQL Database error

    Yup, that's correct. What's the result of doing 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

    March 4, 2017 at 2:36 pm

    #1931677

  • RE: Please explain difference between these terms

    larsp777se - Friday, March 3, 2017 3:30 AM

    larsp777se - Friday, March 3, 2017 3:27 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

    March 3, 2017 at 3:37 am

    #1931444

Viewing 15 posts - 1,696 through 1,710 (of 49,552 total)