Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/11/2015)

    The silver spoons need to be ordered again. Better get at least a case.

    Here's a quote I don't think I've every seen before:

    Unfortunately I get your code...

    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

    August 11, 2015 at 8:20 am

    #1818971

  • RE: Application Taking More Time(Hang)

    Eric M Russell (8/11/2015)

    GilaMonster (8/11/2015)

    Grant Fritchey (8/11/2015)

    mohan_padekal (8/11/2015)

    First i updated Statistics of DataMaster table then try to execute the script that time getting error

    Updating statistics won'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

    August 11, 2015 at 7:19 am

    #1818935

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    GilaMonster (8/11/2015)

    Grant Fritchey (8/11/2015)

    Just saw the news. Congrats Gail.

    It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages...

    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

    August 11, 2015 at 7:12 am

    #1818928

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    Just saw the news. Congrats Gail.

    It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages and submitted 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

    August 11, 2015 at 6:52 am

    #1818913

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/11/2015)

    GilaMonster (8/11/2015)

    Koen Verbeeck (8/11/2015)

    Dammit!

    😀

    I blame the slow internet connection. 😀

    You mean my slow internet connection?

    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

    August 11, 2015 at 6:46 am

    #1818905

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/11/2015)

    Dammit!

    😀

    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

    August 11, 2015 at 6:39 am

    #1818896

  • RE: Are the posted questions getting worse?

    And in unrelated news, something of moderate interest might be happening this afternoon/tonight (depending on timezones). Watch twitter.

    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

    August 11, 2015 at 6:38 am

    #1818892

  • RE: Are the posted questions getting worse?

    Grant would love this query. Views within views within views with a CTE and a temp table for good measure. Parse time is around 45 seconds.

    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

    August 11, 2015 at 6:36 am

    #1818888

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    We've reached page 5000 on the standard layout, so only a couple of more to cross the 50,000 post line. Is anyone going to just post them 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

    August 11, 2015 at 6:35 am

    #1818887

  • RE: Performance query issue leading to Timeout

    Don't go by the cost %. If you use STATISTICS TIME, which query in the batch is taking the longest time?

    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

    August 11, 2015 at 3:58 am

    #1818839

  • RE: Application Taking More Time(Hang)

    Grant Fritchey (8/11/2015)

    mohan_padekal (8/11/2015)

    First i updated Statistics of DataMaster table then try to execute the script that time getting error

    Updating statistics won't change the names 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

    August 11, 2015 at 3:44 am

    #1818837

  • RE: Application Taking More Time(Hang)

    mohan_padekal (8/11/2015)

    Getting this error while execute the script

    Msg 207, Level 16, State 1, Line 24

    Invalid column name 'last_rows'.

    Just remove the last_rows from the select clause then run it. 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

    August 11, 2015 at 3:43 am

    #1818835

  • RE: Error: 5171, Severity: 16 CREATE DATABASE for tempdb on SQL startup

    You need to either create that path so that the file can be created, or start SQL in single user mode (remote in to the server and work directly) 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

    August 10, 2015 at 2:41 pm

    #1818749

  • RE: Archiving Data Script

    Welsh Corgi (8/10/2015)

    I had a Loop to limit the batch size.

    If you want it in a transaction so you can roll it back, it is pointless to do it 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

    August 10, 2015 at 2:36 pm

    #1818743

  • RE: Can I display all the days in a range even with no data ?

    Yes it is. Add in to the OR set OR a.TRANSTYPE IS NULL and replace b.SERVTYPE = ' 5' with (b.SERVTYPE = ' 5' OR b.SERVTYPE IS NULL)

    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

    August 10, 2015 at 9:55 am

    #1818623

Viewing 15 posts - 5,056 through 5,070 (of 49,552 total)