Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 49,552 total)

  • RE: Why I can not search all records in my fn_dblog

    GilaMonster (12/3/2015)

    Why do you say it's never truncated? What recovery model, what backups are scheduled?

    ???

    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

    December 4, 2015 at 1:49 am

    #1843985

  • RE: Need some assistance on to stop a query if value = 0

    Probably something like

    IF @Parameter=1

    SELECT...

    but that's guessing without seeing the 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

    December 4, 2015 at 1:48 am

    #1843983

  • RE: Performance with Referencing or not referencing, index or with index?

    shamshad.ali (12/3/2015)

    a) (MasterId, ID) OR (ID, MasterID)

    Um...

    you probably want an index on (MasterID, ID)

    create one on (MasterID, ID)

    As I specified it. (MasterID, ID)

    How many times do I have to say...

    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

    December 3, 2015 at 7:36 am

    #1843764

  • RE: Why I can not search all records in my fn_dblog

    Why do you say it's never truncated? What recovery model, what backups are scheduled?

    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

    December 3, 2015 at 2:25 am

    #1843710

  • RE: Performance with Referencing or not referencing, index or with index?

    shamshad.ali (12/2/2015)

    i) Should I use the sequence first Detail.MasterId then Detail.Id or first Detail.Id then Detail.MasterId?

    As I specified it. (MasterID, ID)

    ii) Developers should use exactly the same sequence in where...

    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

    December 3, 2015 at 1:13 am

    #1843703

  • RE: writing queries that easily readable

    Rich Mechaber (12/2/2015)

    GilaMonster (12/1/2015)

    Awesome Gail, thank you: that is hand's down the best version of the aphorism "never time to do it right, always time to do it twice" 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

    December 2, 2015 at 1:27 pm

    #1843622

  • RE: Can someone point me to a good resource in the internet

    Check the Stairways here (stairways link in the left-hand side menu) and read the stairway to indexes

    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

    December 2, 2015 at 10:53 am

    #1843596

  • RE: Performance with Referencing or not referencing, index or with index?

    shamshad.ali (12/2/2015)

    In my given scenario, do I need any index or not, back to my first question ?

    Which I have answered. Twice.

    GilaMonster (11/26/2015)

    you probably want an index on (MasterID,...

    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

    December 2, 2015 at 9:16 am

    #1843551

  • RE: Are the posted questions getting worse?

    jasona.work (12/2/2015)

    //me doesn't always terminate statements with a semi-colon

    ///semi-colon;

    Neither do I, though I fix that any time I notice the mistake. I don't however start statements with terminators.

    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

    December 2, 2015 at 9:14 am

    #1843550

  • RE: Confused about VLFs in Full recovery model.

    Let me guess

    You created the database, set the recovery model and then started to test?

    Until a database has had a full backup, it runs in pseudo-simple recovery because there's nothing...

    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

    December 2, 2015 at 9:13 am

    #1843549

  • RE: writing queries that easily readable

    xsevensinzx (12/2/2015)

    I'm saying the one statement where not having a properly terminated statement above it could cause the code to error as a bug, could benefit from always ensuring 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

    December 2, 2015 at 9:05 am

    #1843547

  • RE: Caching database

    One of the first things you need to do is determine whether adding complexity is necessary. Thousands of transactions a minute isn't that high all things considered

    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

    December 2, 2015 at 8:42 am

    #1843531

  • RE: Backup the Tail of the Log

    When you want to make the database unavailable after the backup completes.

    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

    December 2, 2015 at 8:39 am

    #1843528

  • RE: writing queries that easily readable

    xsevensinzx (12/2/2015)

    But, you're really splitting hairs here. You're confusing badly written code with human error. Not correctly terminating a statement can happen to anyone just as it does in 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

    December 2, 2015 at 8:35 am

    #1843524

  • RE: writing queries that easily readable

    Oh, and also...

    MERGE must be terminated with a ;

    THROW requires that the previous statement be terminated with a ; (although there's no error in most cases if you don't, try...

    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

    December 2, 2015 at 8:28 am

    #1843514

Viewing 15 posts - 4,096 through 4,110 (of 49,552 total)