Forum Replies Created

Viewing 15 posts - 24,016 through 24,030 (of 49,552 total)

  • RE: *= non ansi join

    Are you absolutely sure it's a table? Because there's no join at all in that procedure, it's valid for SQL 2005/2008.

    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 22, 2011 at 10:58 am

    #1371576

  • RE: search for sp which jobs calls it

    Yes. Query msdb.dbo.sysjobsteps

    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 22, 2011 at 10:52 am

    #1371572

  • RE: qyery taking an hour

    New question, 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

    August 22, 2011 at 10:47 am

    #1371566

  • RE: how to move index pages to another NDF file from MDF file?

    Marios Philippopoulos (8/22/2011)

    But to come out and say this does not matter, is I think a stretch, especially after there is some evidence to the contrary.

    I never said that 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

    August 22, 2011 at 10:42 am

    #1371562

  • RE: A stupid question - warm standby database switch back to primary database

    Then your failback is entirely manual and you must figure out how to get the data back. Replication is not strictly a HA/DR technology.

    You could use something like RedGate's SQLDataCompare,...

    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 22, 2011 at 10:35 am

    #1371556

  • RE: What happens if the Domain Controller is down?

    The service will still run and you can still log in.

    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 22, 2011 at 10:31 am

    #1371551

  • RE: Huge transaction log backup

    SanDroid (8/22/2011)

    GilaMonster (8/22/2011)

    Recompiles aren't logged.

    Besides, procedures aren't recompiled when the statistics update. They recompile next time they run if they used any of the statistics that changed.

    Good to know. ...

    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 22, 2011 at 10:30 am

    #1371550

  • RE: Huge transaction log backup

    Ninja's_RGR'us (8/22/2011)

    Let's say that you run update stats but the distribution didn't really change, nor the min / max values.

    Do you still get a plan recompile at next run?

    Yes.

    Getting way...

    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 22, 2011 at 10:23 am

    #1371541

  • RE: tricky query

    Ninja's_RGR'us (8/22/2011)

    GilaMonster (8/22/2011)

    Ninja's_RGR'us (8/22/2011)

    P.S. when something runs 10X slower than something else, the plan is NOT the same... or should not be the same.

    Unless there's major blocking/waits on the 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

    August 22, 2011 at 10:22 am

    #1371539

  • RE: tricky query

    Lucky9 (8/22/2011)

    I am sorry everyone... I cannot post more Information...

    I know it is hard to reply with answer without proper information....but i cannot post more Information...

    In which case we cannot...

    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 22, 2011 at 10:21 am

    #1371537

  • RE: Huge transaction log backup

    Recompiles aren't logged.

    Besides, procedures aren't recompiled when the statistics update. They recompile next time they run if they used any of the statistics that changed.

    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 22, 2011 at 10:17 am

    #1371532

  • RE: tricky query

    Ninja's_RGR'us (8/22/2011)

    P.S. when something runs 10X slower than something else, the plan is NOT the same... or should not be the same.

    Unless there's major blocking/waits on the slow one.

    But this...

    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 22, 2011 at 10:17 am

    #1371530

  • RE: A stupid question - warm standby database switch back to primary database

    Depends on what technology you're using to create that warm standby. Mirroring or log shipping?

    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 22, 2011 at 10:09 am

    #1371521

  • RE: tricky query

    There is no way we can provide a sensible answer with that little information. Need the execution plan at a minimum.

    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 22, 2011 at 10:08 am

    #1371520

  • RE: Huge transaction log backup

    There is more than just the stats updates in your log then. The stats updates alone are not going to log 7GB of an 8GB database.

    I would not expect the...

    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 22, 2011 at 10:05 am

    #1371516

Viewing 15 posts - 24,016 through 24,030 (of 49,552 total)