Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 49,552 total)

  • RE: Bingle is my Senior DBA

    Stefan LG (10/10/2016)

    Companies might also provide incentive in terms of money to employees that publish articles on public forums.

    Mine does that, and they don't require any name dropping at 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

    October 11, 2016 at 3:52 am

    #1905844

  • RE: How to Make a SQL Query Run Faster

    Here's the query formatted to be readable. A single query roughly 850 lines long. Tuning that will take a professional days, and will probably involve splitting the query up into...

    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 11, 2016 at 3:45 am

    #1905840

  • RE: How to Make a SQL Query Run Faster

    John Roy Ellis (10/10/2016)

    One thing that I tried that frankly did not help was to place SQL's "WITH(INDEX(..." syntax, after the name of every "from " clause.

    Since I had never...

    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 11, 2016 at 3:36 am

    #1905838

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/10/2016)

    Hugo, are you heading west (over the Atlantic) or east (over the Pacific) on your Amsterdam to Seattle leg?

    North. The flight goes over Greenland and Canada. Doesn't technically...

    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 10, 2016 at 12:33 pm

    #1905750

  • RE: Deadlocks - what am I missing?

    No worries, deadlocks can get fairly hairy.

    Shameless self-promotion: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    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 10, 2016 at 12:29 pm

    #1905749

  • RE: Deadlocks - what am I missing?

    You're misreading the deadlock graph.

    The session running the select holds an S lock , and it's requesting an S lock.

    The select is process5696e08

    resource-list

    pagelock fileid=5 pageid=96510 dbid=5 objectname=<DBName>.<schema>.Vehicles...

    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 10, 2016 at 10:41 am

    #1905708

  • RE: Inaccurate executeion_count(s) in dm_exec_procedure_stats

    Also keep in mind that RPC completed is fired when the application calls a procedure directly procedure. If the application calls a procedure which then calls the one you're investigating,...

    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 10, 2016 at 8:14 am

    #1905662

  • RE: Which of the 2 queries is better in terms of performance

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    And seconding Grant, plan costs are NOT durations and not a good indication of duration

    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 10, 2016 at 6:57 am

    #1905648

  • RE: Are the posted questions getting worse?

    rodjkidd (10/10/2016)

    You aren't flying Delta are you on your flight out?

    Hell no. After their mess last year I'm done with Delta. Standardising to BA for all flights, local and international...

    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 10, 2016 at 5:45 am

    #1905633

  • RE: Are the posted questions getting worse?

    Ah, why not.

    I get to Seattle Sunday 23rd Oct (via London)

    Monday afternoon: Jason's Freecon (monday morning = sleeping in)

    Tuesday probably Pass UG and/Or SQLSaturday meetings, though my UG leader is...

    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 10, 2016 at 4:41 am

    #1905625

  • RE: Upgrading from 2008 r2 to SQL 2016

    You need to test carefully. One of the changes to SQL 2014 was to the query optimiser. Most queries either improve slightly in performance or stay the same, but you...

    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 10, 2016 at 3:42 am

    #1905617

  • RE: What do you do or think about on the way to work?

    Whatever the podcast or lecture that I'm listening to is about.

    I listen to Dot Net Rocks, RunAs Radio, Writing Excuses and, when I run out of podcasts, university lectures via...

    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 10, 2016 at 2:46 am

    #1905606

  • RE: How to know query completion time from actual query plan?

    Ramdas Baghel (10/9/2016)

    Is there anyway to find query completion time (how much time query took to complete) FROM Actual Query Plan?

    No, there is not.

    Besides, a plan extracted from cache...

    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 10, 2016 at 2:38 am

    #1905604

  • RE: Msg 3013, Level 16, State 1, Line 2 BACKUP DATABASE is terminating abnormally.

    mnadirwk (10/6/2016)

    add MAXTRANSFERSIZE= 1048576

    Why?

    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 6, 2016 at 3:42 pm

    #1905283

  • RE: conditional where clause

    ChrisM@home (10/6/2016)

    Sure you could mess it all up by adding something rowcount-sensitive to the query

    Like a key lookup due to a noncovering index on that single table. Yes, the trivial...

    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 6, 2016 at 3:37 pm

    #1905282

Viewing 15 posts - 2,251 through 2,265 (of 49,552 total)