Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 49,552 total)

  • RE: query time out from .net code

    sqlfriends - Friday, May 19, 2017 1:09 PM

    Thanks all.

    But the problem is we don't know what query  that caused this problem. could...

    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

    May 19, 2017 at 2:03 pm

    #1943388

  • RE: Query multiple unrelated tables into one data set

    lmacdonald - Friday, May 19, 2017 11:39 AM

    I don't understand why you had to use MAX considering there is only one value...

    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

    May 19, 2017 at 12:55 pm

    #1943376

  • RE: query time out from .net code

    Your query is taking longer than 30 seconds to run, so the .net app cancels it (that's what a timeout is). Identify the query, see if you can tune it...

    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

    May 19, 2017 at 12:53 pm

    #1943374

  • RE: Query multiple unrelated tables into one data set

    CROSS JOIN them (the three queries), however you'll get three rows back because of your query to sys.configurations.

    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

    May 19, 2017 at 10:35 am

    #1943353

  • RE: Updating Non clustered indexes included columns or 2nd + columns

    It can do a seek, since it'll have already updated the clustered index, and hence knows all the values of the other columns in the row that's been changed.

    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

    May 19, 2017 at 8:50 am

    #1943330

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Friday, May 19, 2017 7:49 AM

    Is anyone else experiencing this? When I type into a post, as I'm doing...

    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

    May 19, 2017 at 8:45 am

    #1943328

  • RE: Performance degraded after migrating to 2016 from 2012

    sarang1183 - Thursday, May 18, 2017 8:13 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

    May 19, 2017 at 6:44 am

    #1943283

  • RE: Performance degraded after migrating to 2016 from 2012

    Ed Wagner - Thursday, May 18, 2017 9:06 PM

     I've found that most things run faster in 2016 than in 2012, but I've...

    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

    May 19, 2017 at 6:42 am

    #1943282

  • RE: Performance degraded after migrating to 2016 from 2012

    sarang1183 - Thursday, May 18, 2017 12:38 PM

    Thanks for showing interest to  understand the query. But unfortunately being SOX audited application, 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

    May 18, 2017 at 3:35 pm

    #1943212

  • RE: Performance degraded after migrating to 2016 from 2012

    sarang1183 - Wednesday, May 17, 2017 7:04 AM

    So old version of SQL server 2012 works faster than more advanced version of SQL...

    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

    May 18, 2017 at 3:28 pm

    #1943211

  • RE: Are the posted questions getting worse?

    drew.allen - Saturday, May 13, 2017 1:00 PM

    jonathan.crawford - Friday, May 12, 2017 12:30 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

    May 13, 2017 at 5:01 pm

    #1942447

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Friday, May 12, 2017 12:34 PM

    ...and now I'm wondering if I can't buy a Leap controller and a wand and...

    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

    May 13, 2017 at 11:44 am

    #1942435

  • RE: Are the posted questions getting worse?

    rodjkidd - Thursday, May 11, 2017 7:04 AM

    Or give it to someone who is going to Summit 😉
    As it appears, currently,...

    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

    May 11, 2017 at 11:54 am

    #1942208

  • RE: Are the posted questions getting worse?

    Can someone please follow up on this thread? I'm no going to be online much tonight or tomorrow, don't want the OP to feel abandoned
    https://www.sqlservercentral.com/Forums/1875410/Cannot-create-a-row-of-size-8208-which-is-greater-than-the-allowable-maximum-row-size-of-8060?

    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

    May 10, 2017 at 8:40 am

    #1942023

  • RE: Cannot create a row of size 8208 which is greater than the allowable maximum row size of 8060.

    I want to see all the data types, indexes and constraints. Obfuscate the names as much as you like (as long as the changes are consistent between CREATE TABLE and...

    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

    May 10, 2017 at 8:39 am

    #1942022

Viewing 15 posts - 1,441 through 1,455 (of 49,552 total)