Forum Replies Created

Viewing 15 posts - 271 through 285 (of 49,552 total)

  • RE: Upgrade to 2014 or 2016

    kevin.obrien 66193 - Wednesday, March 7, 2018 1:54 AM

    GilaMonster - Tuesday, March 6, 2018 5:13 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 7, 2018 at 2:56 am

    #1982196

  • RE: Datatype Change

    Look at your LINQ. Is it still mapping the column as ascii text?

    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 7, 2018 at 1:03 am

    #1982193

  • RE: What Extended Events should I use?

    The events I suggested aren't just for seeing whether someone ran dropcleanbuffers. If the cause is not so obvious, it's still going to be related to what's running at 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 7, 2018 at 1:02 am

    #1982192

  • RE: Why does my stored procedure return -1?

    Jeff Moden - Tuesday, March 6, 2018 8:03 PM

    I'll also add that all those IN (SELECT DISTINCTs are a waste of clock...

    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 7, 2018 at 12:44 am

    #1982190

  • RE: What Extended Events should I use?

    I'd probably start with sql_batch_completed and rpc_completed and see if I could figure out what statements were being run at the time the problems happen.

    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, 2018 at 9:19 am

    #1982094

  • RE: Upgrade to 2014 or 2016

    SQL 2012 is out of support and has been for over a year. 2014 will be out of support next year. Upgrading to either of them at this point in...

    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, 2018 at 5:13 am

    #1982064

  • RE: Upgrade to 2014 or 2016

    I recommend upgrading to SQL 2017. No reason to upgrade to something almost 2 years old, and 14 has nothing to recommend it against the alternatives (not unstable, it's perfectly...

    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, 2018 at 5:01 am

    #1982061

  • RE: CXPACKET wait time hours

    No, it's a lot more complex than that.

    A couple of the threads are waiting on async network io. They have the async network io wait and are counting...

    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, 2018 at 9:07 am

    #1981969

  • RE: Is this Deadlock due to Lock Partitions?

    You need to identify the SELECT that is happening before the update on the table named tbl, and why it needs a table-level shared lock.

    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, 2018 at 9:02 am

    #1981968

  • RE: CXPACKET wait time hours

    Async network io is usually waiting for the app to accept the data.

    If the app accepts a row, does something with the row, displays it or asks 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 5, 2018 at 6:02 am

    #1981927

  • RE: Moving SSISDB off C drive

    ALTER DATABASE ... MODIFY FILE for both the mdf and the ldf to point then at the new directory.
    Then take the DB offline  if you can (don't know whether...

    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, 2018 at 4:38 am

    #1981917

  • RE: Transparent data encryption

    vsamantha35 - Monday, March 5, 2018 12:42 AM

    Hi All,
    Can a TDE database be viewed / hacked by a login with sysadmin pemissions...

    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, 2018 at 12:48 am

    #1981907

  • RE: How to bring database just before the delete occurred.

    Ivan R. - Sunday, March 4, 2018 6:25 PM

    hahaha im really curious to see if this is an actual problem or interview...

    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, 2018 at 12:30 am

    #1981906

  • RE: updates are not happening through ssms

    Since I can't exactly run that, please post the resultant trigger that is on your table?

    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, 2018 at 5:17 am

    #1981881

  • RE: Is this Deadlock due to Lock Partitions?

    Sergiy - Saturday, March 3, 2018 3:08 PM

    Both statements have this in their lock description:transactionname="implicit_transaction"It kinda indicates that there is no explicit...

    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, 2018 at 3:39 pm

    #1981861

Viewing 15 posts - 271 through 285 (of 49,552 total)