Forum Replies Created

Viewing 15 posts - 30,331 through 30,345 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (9/28/2010)

    How do you kick them off your client list, Gail? What do you typically say when deciding not to work as a consultant for them any longer?

    Depends on...

    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

    September 28, 2010 at 5:13 am

    #1228257

  • RE: BACKUP LOG with trucate_only

    That discards inactive log records and does not write a backup file out.

    It will break your log chain, meaning you cannot take log backups or do point in time recovery...

    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

    September 28, 2010 at 4:03 am

    #1228226

  • RE: Need help on query

    You cannot use = and <> when comparing to NULL. Such comparisons always return UNKNOWN (assuming default ansi_null settings)

    Try this (formatted so that it's easier to read)

    SELECT a.PerFirstJobDate, a.PerFirstName, c.JouDateEnd

    ...

    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

    September 28, 2010 at 3:04 am

    #1228208

  • RE: Group by vs. Distinct

    If you're aggregating (sum, avg, count, etc) then Group By.

    If you're looking for unique rows then Distinct.

    This falls into the category of being obvious what you're doing.

    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

    September 28, 2010 at 2:57 am

    #1228204

  • RE: Optimizing Server Config & DB Config etc

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 28, 2010 at 2:53 am

    #1228201

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/27/2010)

    GilaMonster (9/27/2010)

    Tom.Thomson (9/27/2010)

    Sturgeon got it wrong. He should have said 95%. At least of the developers I have interviewed I regard 95% as unemployable in any...

    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

    September 28, 2010 at 2:44 am

    #1228199

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/27/2010)

    Sturgeon got it wrong. He should have said 95%. At least of the developers I have interviewed I regard 95% as unemployable in any sanely managed company...

    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

    September 27, 2010 at 2:19 pm

    #1227998

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/27/2010)

    Stefan Krzywicki (9/27/2010)

    CirquedeSQLeil (9/27/2010)

    Brandie Tarvin (9/27/2010)

    Anybody know of a way to track readers on LJ?

    What is LJ?

    LJ is Live Journal. Some like the site, some hate it. I just...

    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

    September 27, 2010 at 12:08 pm

    #1227896

  • RE: DBCC CHECKDB - how use it in a maintenance plan ?

    Please rather post new questions in a new thread. Thanks

    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

    September 27, 2010 at 12:06 pm

    #1227893

  • RE: DBCC CHECKDB Error Msg 2570, Level 16, State 3

    Glad to hear 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

    September 27, 2010 at 11:56 am

    #1227888

  • RE: DBCC CHECKDB Error Msg 2570, Level 16, State 3

    What you need to do is work out (from DBCC Page) what the values for the primary key are for those rows. Then do an update (using those pk values...

    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

    September 27, 2010 at 9:52 am

    #1227785

  • RE: SSIS package terminating unexpectedly

    Think I may have gotten to the bottom of this.

    The cluster that SSIS sits on has been throwing some rather nasty disk-related errors and has been failing over multiple times...

    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

    September 27, 2010 at 7:17 am

    #1227675

  • RE: Database issue with missing transaction log, cannot backup or copy the database

    Apologies, I haven't had chance to try and repo this situation to see how (if) it can be solved. Are you OK with recreating the DB?

    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

    September 27, 2010 at 5:43 am

    #1227624

  • RE: Improve performance--need help

    Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    September 27, 2010 at 4:17 am

    #1227596

  • RE: Query plan changes by usage of variables instead of values, Why?

    http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

    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

    September 27, 2010 at 3:27 am

    #1227581

Viewing 15 posts - 30,331 through 30,345 (of 49,552 total)