Forum Replies Created

Viewing 15 posts - 42,601 through 42,615 (of 49,552 total)

  • RE: Minatanace plan for backup

    So where did you set the maintenance plan up from?

    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, 2008 at 12:54 am

    #907396

  • RE: How to get the print message in sproc

    It should be possible, but I don't know enough about Java to know how. Perhaps ask that on a java forum?

    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, 2008 at 12:47 am

    #907393

  • RE: Proc is giving poor performance

    Skull Killer (12/3/2008)

    Its not necessary to create a physical temporary table since it's a small one that works better in memory.

    Just to clarify. Temp tables and table variables are...

    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, 2008 at 12:32 am

    #907388

  • RE: Integrity Check -- DBCC

    I don't think that dropping the keys is going to get rid of all the messages. Some, maybe.

    As well as foreign keys with missing key column info (which dropping 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

    December 4, 2008 at 12:28 am

    #907385

  • RE: Minatanace plan for backup

    And what's the version of your client tools? Help - about management studio.

    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, 2008 at 12:25 am

    #907383

  • RE: Severe Error

    Mike Levan (12/3/2008)

    In general what wud be the reason behind the few db's going into recovery state every time after restarting the server though i dont have any pending trasaction...

    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, 2008 at 3:29 pm

    #907213

  • RE: Severe Error

    Is that error log you just posted from the same system that had the 823 errors? It doesn't appear to be so, the database names are different.

    Is the system 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

    December 3, 2008 at 3:14 pm

    #907207

  • RE: Severe Error

    Have you checked the system event log for hardware-related errors?

    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, 2008 at 2:52 pm

    #907192

  • RE: Begin Tran...Execute (@Query)...Commit causing very slow query

    The other question to ask is why dynamic SQL?

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

    #907178

  • RE: Severe Error

    Please post the latest SQL error log. The one after the latest reboot.

    Have you checked the system event log for hardware-related errors?

    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, 2008 at 2:22 pm

    #907176

  • RE: SQL Data and Log Files

    Replication can work in simple recovery. It's mirroring and log shipping that require full only (for mirroring) or full or bulk-logged (I think for log shipping). I seem to recall...

    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, 2008 at 2:16 pm

    #907169

  • RE: Any sql-db-related objects updated?

    umanpowered (12/3/2008)

    I was thinking there would be a "last update" column on some type of data-table, from what I gathered from what Grant was explaining, that I could use...

    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, 2008 at 2:07 pm

    #907161

  • RE: Severe Error

    Mike Levan (12/3/2008)

    what is the reason?

    No idea. Can you please post the information I asked for.

    The latest error log (the one that was started after you restarted the server...

    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, 2008 at 2:04 pm

    #907155

  • RE: Questions about full database backup

    Phil Auer (12/3/2008)

    It talks about the pitfalls of running ad-hoc backups and, if I understand correctly, says that it will basically render the previous full backup unusable.

    Adhoc fulls don't render...

    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, 2008 at 1:51 pm

    #907143

  • RE: Missing Statistics IO y Time

    If the showplans aren't on, where does this come from?

    StmtText

    ----------------------------------------------------------------------------------------------------------------------------------------------

    select a.rut_empleado

    from ANTECEDENTE_CONTRACTUAL a

    WHERE exists(select 1 from CENTRO_COSTO x

    ...

    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, 2008 at 1:49 pm

    #907141

Viewing 15 posts - 42,601 through 42,615 (of 49,552 total)