Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (11/16/2016)

    First CTP will come out soon (if it isn't already - the date was announced at PASS but I forgot)

    Available for download: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-vnext-ctp

    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

    November 16, 2016 at 9:22 am

    #1912838

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (11/16/2016)

    Grant Fritchey (11/16/2016)

    All that, and the vNext is also on Windows.

    True, but way more exciting is that it'll also be on Linux. 😛

    And Mac, and in Docker containers.

    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

    November 16, 2016 at 9:20 am

    #1912835

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/16/2016)

    Question, any way to get these keynotes to view later? I would like to share these with others here at work. Plus, I came in late.

    Yes....

    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

    November 16, 2016 at 9:19 am

    #1912834

  • RE: Are the posted questions getting worse?

    jasona.work (11/16/2016)

    My response to that was two words, one of which I shouldn't use in polite company and the first was "holy"

    :w00t:

    I was screaming at my monitor last night.

    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

    November 16, 2016 at 9:15 am

    #1912829

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/16/2016)

    Care to drop any hints?

    No. Not until the announcements are made.

    Check Twitter later (Grant, Tom LaRock, Kendra, etc) they should be tweeting the highlights (I'm trying 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

    November 16, 2016 at 8:12 am

    #1912807

  • RE: Are the posted questions getting worse?

    For everyone here, if you can, watch the keynote of https://connectevent.microsoft.com/, starting in the next few minutes. There are reasons.

    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

    November 16, 2016 at 7:51 am

    #1912798

  • RE: how to find the users who deleted the records from the sql table

    Phil Parkin (11/16/2016)

    Is it possible to return the underlying T-SQL which relates to a particular transaction Id?

    Possibly via the sys.dm_tran_active_transactions DMV, providing the transaction is still active, but in general...

    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

    November 16, 2016 at 7:40 am

    #1912793

  • RE: Data is not ordered correctly with pagination - Sql Server 2012

    You need an ORDER BY on the outer query. Without said ORDER BY, the optimiser is free to choose plans that return the data in any order at all, as...

    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

    November 16, 2016 at 7:36 am

    #1912790

  • RE: how to find the users who deleted the records from the sql table

    That only works if the log records are still in the transaction log (which means you need to be doing the investigation very soon after the delete; minutes, not days),...

    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

    November 16, 2016 at 7:08 am

    #1912780

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/16/2016)

    So I did a quick google on polenta and found this interesting article.

    I love the Serious Eats site. Good recipes, good discussions.

    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

    November 16, 2016 at 6:05 am

    #1912761

  • RE: Stupid question? How to exclude 'SA' using sp_who

    Don't use sp_who (it dates back to pre-SQL 2000 and has not, afaik, been updated for the new DMVs and new information available)

    Build your own query from the DMVs (sys.dm_exec_sessions...

    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

    November 16, 2016 at 2:21 am

    #1912713

  • RE: transaction log, bulk-logged recovery model, DBAs

    Point your DBA at this: http://www.sqlservercentral.com/articles/books/94938/

    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

    November 16, 2016 at 2:12 am

    #1912711

  • RE: check if record exists then update else insert

    Some concurrency matters to keep in mind: http://source.entelect.co.za/why-is-this-upsert-code-broken

    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

    November 15, 2016 at 1:50 pm

    #1912662

  • RE: what is compile wait resource and how to resolve it

    farax_x (11/15/2016)

    GilaMonster (11/15/2016)

    You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down...

    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

    November 15, 2016 at 8:27 am

    #1912543

  • RE: Tables that start with "DIM" missing in AdventureWorksDatabase2012 - Please help

    Sorry, didn't notice you had SQL Server 2012

    Go to this link rather https://msftdbprodsamples.codeplex.com/releases/view/55330, and download the second item there "AdventureWorksDW2012 Data File " and follow the instructions further down 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

    November 15, 2016 at 7:20 am

    #1912496

Viewing 15 posts - 2,086 through 2,100 (of 49,552 total)