Forum Replies Created

Viewing 15 posts - 676 through 690 (of 49,552 total)

  • RE: Changing NVARCHAR to VARCHAR...

    Jason A. Long - Wednesday, November 1, 2017 12:25 AM

    EDIT: Just for clarification...Even if I had been 100% correct, I wouldn't...

    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 1, 2017 at 1:03 pm

    #1966277

  • RE: Are the posted questions getting worse?

    @Lynn

    Regarding your earlier question about a version of SSMS for Linux, announced this morning was SQL Operations Studio (aka Project Carbon), a cross platform SQL client for Windows,...

    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 1, 2017 at 12:54 pm

    #1966274

  • RE: Changing NVARCHAR to VARCHAR...

    Jason A. Long - Tuesday, October 31, 2017 9:48 PM

    Getting rid of NVARCHARs has a benefit that (IMO) far out weighs any...

    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

    October 31, 2017 at 10:10 pm

    #1966109

  • RE: DBCC CHECKDB with Msg 8921, Msg 824

    jaganeee - Tuesday, October 31, 2017 8:49 PM

    I can’t able to get the required table data.Is it possible to update 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

    October 31, 2017 at 9:02 pm

    #1966103

  • RE: What uncompresses tables/indexes?

    Something or someone is rebuilding the indexes and removing compression, or dropping and recreating the indexes without compression.
    Put some auditing in place on DDL statements and identify where...

    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

    October 31, 2017 at 12:32 pm

    #1966048

  • RE: Table partitioning with 2016 standard edition

    Then you're looking at a sliding window scenario. There's lots of documentation available on how to do 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

    October 31, 2017 at 11:38 am

    #1966031

  • RE: Table partitioning with 2016 standard edition

    If you're after better performance, don't waste your time. Partitioning is not for performance, it's for data management, fast loads, fast deletes.

    If you want to be able to...

    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

    October 31, 2017 at 11:23 am

    #1966027

  • RE: What uncompresses tables/indexes?

    Do you mean that you're looking at a later date and seeing the indexes as uncomressed (Compression = None)?

    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

    October 31, 2017 at 11:21 am

    #1966025

  • RE: Table partitioning with 2016 standard edition

    Once you've got SP1, then partitioning is the same as for Enterprise edition.

    That said, why are you considering partitioning? What's your goal?

    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

    October 31, 2017 at 10:25 am

    #1966017

  • RE: DBCC CHECKDB with Msg 8921, Msg 824

    jaganeee - Tuesday, October 31, 2017 7:06 AM

    i haven't backup any log, differential or full backup recently.
    full backup on Jan 8.
    is there...

    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

    October 31, 2017 at 10:24 am

    #1966016

  • RE: Best DB advice - very basic and general

    tommyleo - Tuesday, October 31, 2017 1:40 AM

    Can you reccomend off-the-shelf database?

    Application, not database. Application will be a combo of forms,...

    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

    October 31, 2017 at 10:19 am

    #1966013

  • RE: Best DB advice - very basic and general

    tommyleo - Monday, October 30, 2017 9:32 AM

    FridayNightGiant - Thursday, October 26, 2017 2:47 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

    October 30, 2017 at 7:21 pm

    #1965879

  • RE: Extended Events - sqlserver.query_memory_grant_usage

    SteveOC - Monday, October 30, 2017 7:57 AM

    Couldn't think of any reason why it didn't work, so was just wondering if 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

    October 30, 2017 at 7:07 pm

    #1965877

  • RE: Extended Events - sqlserver.query_memory_grant_usage

    SteveOC - Sunday, October 29, 2017 9:31 AM

    GilaMonster - Sunday, October 29, 2017 9:24 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

    October 29, 2017 at 10:23 pm

    #1965719

  • RE: Extended Events - sqlserver.query_memory_grant_usage

    Interesting. Looks like they back-ported it down to 2014 in SP2. Kinda unexpected.

    What's SELECT @@Version on that server?

    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

    October 29, 2017 at 9:24 am

    #1965698

Viewing 15 posts - 676 through 690 (of 49,552 total)