Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    rodjkidd (4/29/2016)

    SQLBits - make sure to say hi ... It will be good to catch up with the usual mob (Gail, Steve, Grant etc... 😉 )

    Errr....

    http://sqlinthewild.co.za/index.php/2016/04/26/upcoming-conferences/

    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

    April 29, 2016 at 8:02 am

    #1875587

  • RE: Moving databases from one server to another. Server1 uses 2008 sql server and server 2 uses 2014 sql server

    Start by doing a full workload performance test, or you'll likely be posting a similar thread to this afterwards: http://www.sqlservercentral.com/Forums/Topic1781716-3412-1.aspx

    Once you've got all the testing done and fixed the queries...

    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

    April 29, 2016 at 6:07 am

    #1875540

  • RE: Are the posted questions getting worse?

    BLOB_EATER (4/29/2016)

    GilaMonster (4/29/2016)

    GilaMonster (4/27/2016)

    BLOB_EATER (4/27/2016)

    GilaMonster (4/26/2016)

    BLOB_EATER (4/26/2016)

    GilaMonster (4/26/2016)

    SQLRNNR (4/26/2016)

    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according...

    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

    April 29, 2016 at 5:58 am

    #1875538

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/29/2016)

    You realize, Gail, that you are a horrible person for this... don't you?

    I'm a bibliophile. I love books. But we're in the middle of an upgrade and I...

    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

    April 29, 2016 at 4:30 am

    #1875512

  • RE: Are the posted questions getting worse?

    GilaMonster (4/27/2016)

    BLOB_EATER (4/27/2016)

    GilaMonster (4/26/2016)

    BLOB_EATER (4/26/2016)

    GilaMonster (4/26/2016)

    SQLRNNR (4/26/2016)

    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth...

    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

    April 29, 2016 at 3:57 am

    #1875501

  • RE: Simple recovery mode to Full question

    Take a full or differential backup.

    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

    April 28, 2016 at 3:58 pm

    #1875416

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/28/2016)

    Does anyone have The Ball today?

    Mine just reads "Maybe"

    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

    April 28, 2016 at 3:57 pm

    #1875414

  • RE: SQL Server 2008 R2 to 2014 upgrade - performance degradation

    N_Muller (4/28/2016)

    Or is it a hit and miss in terms of queries that perform poorly.

    This.

    If there was only a couple of known patterns of queries that always got performance degradations,...

    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

    April 28, 2016 at 3:57 pm

    #1875413

  • RE: SQL Server 2008 R2 to 2014 upgrade - performance degradation

    Yup, cardinality estimator changes.

    Most queries show a performance improvement, or stay the same under the new CE. A smaller number show degradations. It's why I tell people they MUST test...

    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

    April 28, 2016 at 11:23 am

    #1875356

  • RE: Count differs while using the date values

    Luis Cazares (4/28/2016)

    SELECT count(1)

    FROM sap_plant

    where lastupdate >= @StartDate

    and lastupdate < @EndDate + 1; --No need to change the value from the 'parameter'

    I'd recommend against using that "date...

    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

    April 28, 2016 at 8:26 am

    #1875286

  • RE: free the cache - SQL Server Server

    Jeff Moden (4/28/2016)

    river1 (4/27/2016)

    I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats

    Ah, careful now. Specifically, REORG does NOT rebuild stats. ...

    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

    April 28, 2016 at 8:14 am

    #1875275

  • RE: Storing encypted SSN's

    Eric M Russell (4/27/2016)

    at this point you might as well use symmetric key encryption instead of hashing.

    I disagree. If you're using symmetric encryption and the key is compromised, 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

    April 27, 2016 at 1:16 pm

    #1875048

  • RE: free the cache - SQL Server Server

    Don't guess as to the cause of a problem. You need to do enough analysis and investigation to be sure of the cause before you decide on a solution. 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

    April 27, 2016 at 1:11 pm

    #1875045

  • RE: Are the posted questions getting worse?

    BLOB_EATER (4/27/2016)

    GilaMonster (4/26/2016)

    BLOB_EATER (4/26/2016)

    GilaMonster (4/26/2016)

    SQLRNNR (4/26/2016)

    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious...

    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

    April 27, 2016 at 5:12 am

    #1874889

  • RE: Storing encypted SSN's

    SHA2_512 is the strongest hashing algorithm on SQL 2012. Use that unless you have a good reason to use a weaker algorithm. Edit: and salt it.

    SHA1 has been out of...

    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

    April 26, 2016 at 3:15 pm

    #1874804

Viewing 15 posts - 3,151 through 3,165 (of 49,552 total)