Forum Replies Created

Viewing 15 posts - 5,446 through 5,460 (of 49,552 total)

  • RE: Inner Join Syntax

    Please note: 8 year old thread.

    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

    July 1, 2015 at 3:24 am

    #1809399

  • RE: Windows or SQL authentication?

    Service accounts, as in the account that the SQL Server is running as? No way, that's bad practice.

    Windows authent is good, I prefer it over SQL authent when possible, but...

    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

    July 1, 2015 at 2:44 am

    #1809391

  • RE: Missing .MDF file

    If the DB was in full recovery, and you still have the log file, and you can 'hack attach' the remaining files to a SQL instance of the same version,...

    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

    July 1, 2015 at 2:37 am

    #1809388

  • RE: How to make actual execution plan better?

    Jeff Moden (6/30/2015)

    It seems like a lot of folks don't understand that a non-clustered index is a duplication of data that not only affects queries and space on disk but...

    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

    June 30, 2015 at 11:32 am

    #1809242

  • RE: log_reuse_wait_desc as ACTIVE _TRANSACTION on tempdb

    Log reuse reason, or a large tran log, or a 60% full tran log will not cause queries to run slow.

    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

    June 30, 2015 at 11:10 am

    #1809232

  • RE: How to make actual execution plan better?

    Jason A. Long (6/30/2015)

    (and yes, you are correct... They are bad).

    They are not. They are inefficient on large row counts.

    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

    June 30, 2015 at 11:07 am

    #1809231

  • RE: How to make actual execution plan better?

    Tac11 (6/30/2015)

    Now I get on execution plan with 'key lookup', 'nested loop' operator, which I think are bad.

    No they're not. There are no bad operators, if there were they wouldn'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

    June 30, 2015 at 11:05 am

    #1809230

  • RE: Good White Paper To Go Over How SQL Handles Queries

    Not a whitepaper, but: http://www.amazon.com/Microsoft-Server-Internals-Developer-Reference/dp/0735658560/ref=sr_1_1?s=books&ie=UTF8&qid=1435683605&sr=1-1&keywords=sql+server+internals

    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

    June 30, 2015 at 11:00 am

    #1809227

  • RE: log_reuse_wait_desc as ACTIVE _TRANSACTION on tempdb

    Why is this a concern?

    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

    June 30, 2015 at 7:55 am

    #1809135

  • RE: Space issue in a Particular table.

    Then there's a delete running somewhere else, from a job or another user or something.

    SQL will not delete data by itself. If you have rows disappearing, someone or some job...

    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

    June 30, 2015 at 7:39 am

    #1809121

  • RE: Space issue in a Particular table.

    Check the script, see what it's doing. If there are fewer rows after than before, then something in the script you are running is deleting data. Probably your merge script...

    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

    June 30, 2015 at 7:03 am

    #1809103

  • RE: Are the posted questions getting worse?

    Eeep. Just realised that tomorrow's the 1st of July. Or the 'refresh email every 5 seconds' day.

    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

    June 30, 2015 at 4:56 am

    #1809046

  • RE: Are the posted questions getting worse?

    DBA From The Cold (6/30/2015)

    GilaMonster (6/30/2015)

    Koen Verbeeck (6/30/2015)

    DBA From The Cold (6/30/2015)

    Hey guys, going a bit off topic here but would like some advice please as I know pretty much...

    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

    June 30, 2015 at 3:02 am

    #1809015

  • RE: Space issue in a Particular table.

    SQL will not overwrite existing rows because of a table's size. Look at whatever is doing the insert into the table, from SQL's side, if it's told to do an...

    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

    June 30, 2015 at 2:55 am

    #1809013

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (6/30/2015)

    DBA From The Cold (6/30/2015)

    Hey guys, going a bit off topic here but would like some advice please as I know pretty much all of you are writers/bloggers.

    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

    June 30, 2015 at 2:51 am

    #1809011

Viewing 15 posts - 5,446 through 5,460 (of 49,552 total)