Forum Replies Created

Viewing 15 posts - 8,941 through 8,955 (of 49,552 total)

  • RE: Trace file failed to create table

    Check in SQL that the trace is not running. That is exactly the error you get if you try reading a trace file that is still being written to.

    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

    May 23, 2014 at 3:13 am

    #1715991

  • RE: Trace file failed to create table

    The trace is still running. Stop it first, then load the data.

    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

    May 23, 2014 at 2:59 am

    #1715988

  • RE: What has changed?

    Index maintenance 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

    May 23, 2014 at 2:28 am

    #1715981

  • RE: Corrupt?? Or what is going on

    Sounds about right. 32GB with 27GB free space is roughly 5GB of data. Backjups only back up the data, not free space, so the backup being around 4GB (allowing for...

    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

    May 23, 2014 at 2:27 am

    #1715980

  • RE: SQL Server 2005 problem with transaction log backup failing after full backup

    Something switching recovery models after the backup? Check the SQL error log.

    Edit: Also check the error log for messages indicating explicit log truncation (backup log with truncate_only). It may be...

    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

    May 23, 2014 at 2:22 am

    #1715978

  • RE: Are the posted questions getting worse?

    Steve, can anything be done about shrills like this:

    http://www.sqlservercentral.com/Forums/FindPost1573887.aspx

    He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB 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

    May 23, 2014 at 2:21 am

    #1715977

  • RE: TempTables

    spaghettidba (5/23/2014)

    SELECT ... INTO holds a schema lock on the source table that can end up blocking other processes.

    It does not.

    SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

    BEGIN TRANSACTION

    SELECT * INTO #SomeTable...

    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

    May 23, 2014 at 2:20 am

    #1715974

  • RE: Database in Recovery Pending State

    .

    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

    May 23, 2014 at 2:16 am

    #1715971

  • RE: Are the posted questions getting worse?

    BWFC (5/23/2014)

    Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question?

    No, you get used to 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

    May 23, 2014 at 2:14 am

    #1715969

  • RE: CPU hungry query

    sql-lover (5/22/2014)

    .. due application design, is hard for me to isolate and test with actual parameters, so I replaced some of them.

    Doing so could change the query's execution plan so...

    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

    May 22, 2014 at 11:36 am

    #1715799

  • RE: Views question

    You can't have a cursor in a view.

    Maybe a stored proc, loop over the databases, insert the results into a temp table, query the temp table.

    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

    May 22, 2014 at 11:34 am

    #1715798

  • RE: Sudden CPU % Jump to 100% Usage

    Matt Crowley (5/21/2014)

    As an alternative to Profiler, would the data in sys.dm_exec_query_stats be a better way to get at whether certain queries/stores procs are suddenly getting worse plans? I...

    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

    May 22, 2014 at 11:19 am

    #1715792

  • RE: CPU hungry query

    Table definitions, index definitions please.

    Are the business users happy with the chance of getting incorrect results from this query from time to time?

    And, what's the point of this?

    AND (''='' OR...

    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

    May 22, 2014 at 11:16 am

    #1715789

  • RE: Buffer cache size much lower than Max Memory config + low PLE

    What does the Total Server Memory counter look like?

    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

    May 22, 2014 at 11:08 am

    #1715786

  • RE: Cheats on the move

    Jeff Moden (5/22/2014)

    I always thought that testing facilities would at least check a driver's license for proof of identity.

    They're supposed to. Either fake IDs that are good enough for 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

    May 22, 2014 at 8:36 am

    #1715721

Viewing 15 posts - 8,941 through 8,955 (of 49,552 total)