Forum Replies Created

Viewing 15 posts - 35,881 through 35,895 (of 49,552 total)

  • RE: SQL Tuning where no PK exists

    Sure that's the right execution plan? It shows only a conditional drop object.

    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

    November 12, 2009 at 12:30 pm

    #1078535

  • RE: Sleeping process CPU

    If I'm not mistaken, it gets the info from the session DMV, and that's cumulative since the connection first connected. Sleeping means not currently running anything.

    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

    November 12, 2009 at 12:28 pm

    #1078532

  • RE: DB appears in recovery...

    igngua (11/12/2009)

    The error log is in to the sql agent ??

    No. The SQL server error log. SQL Agent has nothing to do with anything here.

    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

    November 12, 2009 at 12:26 pm

    #1078531

  • RE: SQL Tuning where no PK exists

    Please post 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

    November 12, 2009 at 11:12 am

    #1078498

  • RE: Are the posted questions getting worse?

    Gutter.

    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

    November 12, 2009 at 11:05 am

    #1078495

  • RE: Introduction to Indexes: Part 2 – The clustered index

    mark.stringer (11/12/2009)

    Would you mind expanding on your comment that the problem is not SQL 2000 specific, is it fixed in SQL 2008 for instance?

    Technically, it's not a bug. It's a...

    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

    November 12, 2009 at 10:46 am

    #1078484

  • RE: Sleeping process CPU

    Where are you seeing those 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

    November 12, 2009 at 10:19 am

    #1078466

  • RE: Introduction to Indexes: Part 2 – The clustered index

    Esalter (11/12/2009)

    Presumably SS like most all other DBMS's makes use of a compound key index to search a table when a query is searching on columns that form the major...

    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

    November 12, 2009 at 10:09 am

    #1078461

  • RE: Introduction to Indexes: Part 2 – The clustered index

    mark.stringer (11/12/2009)

    I recently read an article I cannot find now that claimed this could happen when all the indexes on a table were heaps.

    If the table is a heap. Indexes...

    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

    November 12, 2009 at 10:05 am

    #1078459

  • RE: Introduction to Indexes: Part 2 – The clustered index

    bob 54859 (11/12/2009)

    So, the dev in our shop that is against this claimed that when he did this a select query was 10x slower and SQL chose the wrong index....

    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

    November 12, 2009 at 8:36 am

    #1078400

  • RE: Trouble with Distinct in SQL2000

    Here you go. You can use this as a subquery for your aggregations or insert the results into another table.

    SELECT tmp9999.*

    FROM tmp9999 INNER JOIN

    (SELECT MAX(PrimKey) AS MaxKey, ClientNumber, ClientAcctNumber

    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

    November 12, 2009 at 8:29 am

    #1078392

  • RE: Tail backup

    chk2009 (11/10/2009)

    Can we take tail tlog backup even when db is offline/damaged/correpted

    Providing the log is available, yes. If the log is damaged/missing then no. If it's just the mdf/ndf files...

    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

    November 12, 2009 at 8:08 am

    #1078377

  • RE: I have few sqlzoo query command questions

    This looks like homework. Is it?

    Give it a try yourself, if you get stuck, show us what you've done and where you're stuck and we can help.

    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

    November 12, 2009 at 8:07 am

    #1078376

  • RE: DB appears in recovery...

    I'm guessing that SQL restarted. That indicates that SQL is still recovering the DB. Check the error log, what does it say about that 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

    November 12, 2009 at 7:44 am

    #1078352

  • RE: Performance issue due to update statistics

    SP_updatestats takes no locks. It always runs on the entire database. If you want to update just a table, use UPDATE STATISTICS

    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

    November 12, 2009 at 7:32 am

    #1078338

Viewing 15 posts - 35,881 through 35,895 (of 49,552 total)