Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Phil Parkin (8/25/2016)

    All in one hour? Hope you can talk fast 🙂

    That's why I don't want to demo every feature. I can cover that in an hour, but if 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

    August 25, 2016 at 2:24 pm

    #1897658

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/25/2016)

    GilaMonster (8/25/2016)

    If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with...

    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 25, 2016 at 2:05 pm

    #1897651

  • RE: Are the posted questions getting worse?

    BLOB_EATER (8/25/2016)

    Lynn Pettis (8/25/2016)

    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    What on earth is number 19 about? Clr.... VAS?

    Neither, 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

    August 25, 2016 at 12:57 pm

    #1897612

  • RE: Are the posted questions getting worse?

    If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with code/screenshots on slides,...

    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 25, 2016 at 12:49 pm

    #1897608

  • RE: Are the posted questions getting worse?

    A few of them? I don't think a single one is correct.

    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 25, 2016 at 11:59 am

    #1897586

  • RE: LOB data types

    Yup, included columns are part of the index, just like key columns.

    Any query that returns the key columns should return the include columns as well, unless they're getting explicitly filtered...

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

    #1897511

  • RE: Check constraint based on other tables

    mikek 50666 (8/25/2016)

    Thanks Gail, OK if this method will not work what is the correct way to do this?

    This method is about the only way to do it, unless 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

    August 25, 2016 at 5:48 am

    #1897441

  • RE: Confused about backups and recovery models

    That blog post is wrong in a few places.

    This, for example, is wrong.

    Bulk logged recovery model performs much better than simple logged recovery model because it uses minimal log space...

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

    #1897435

  • RE: Check constraint based on other tables

    And be warned that such a constraint doesn't work properly. If, for example, you put a constraint using a scalar udf like that on the TOOL_SET table, it only gets...

    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 25, 2016 at 5:22 am

    #1897433

  • RE: Distributed Replay / Testing

    Yes. It works fine with ad-hoc, prepared or stored procedures.

    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 25, 2016 at 5:16 am

    #1897432

  • RE: How to recover SQL Jobs?

    johnwalker10 (8/24/2016)

    If you have any idea when this occured, you could take a look at agent's log file to see if anything bad happened. It's in a file called SQLAGENT.OUT,...

    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 25, 2016 at 5:15 am

    #1897431

  • RE: sort_in_tempdb

    If you specify SORT_IN_TEMPDB = on for an index CREATE or ALTER, then that CREATE or ALTER will sort in TempDB. If you do not specify it for an index...

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

    #1897430

  • RE: SQL Server Upgrade from 2008 Standard to 2014 or 2016

    Upgrade advisor doesn't import databases. It just checks for possible problems that the DB will have on the new version (using removed features, etc).

    Backup/restore is how we normally get...

    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 24, 2016 at 3:55 pm

    #1897345

  • RE: SQL database files

    What statement did you run to get that?

    What state is the database in? (Online, suspect, recovery pending)

    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 24, 2016 at 3:52 pm

    #1897344

  • RE: LOB data types

    ScottPletcher (8/24/2016)

    I thought a bigint was 8 bytes (rather than 16).

    You are correct. For some reason I was thinking int = 8 when I wrote 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 24, 2016 at 2:35 pm

    #1897330

Viewing 15 posts - 2,536 through 2,550 (of 49,552 total)