Forum Replies Created

Viewing 15 posts - 12,181 through 12,195 (of 49,552 total)

  • RE: select DISTINCT cost too high?

    ananda.murugesan (8/6/2013)

    Before total execution time was 00:00:28 seconds, after that it was just took 00:00:02 seconds after created NC index..But second time actual exex.plan was showing 72% of total...

    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 6, 2013 at 1:52 pm

    #1639103

  • RE: Plugging in a variable column name in a stored procedure

    Before you decide to go and intentionally write code that's vulnerable to SQL injection, maybe take a read through these.

    http://www.computerworld.com/s/article/9241084/SQL_flaws_remain_an_Achilles_heel_for_IT_security_groups

    http://www.troyhunt.com/2013/07/everything-you-wanted-to-know-about-sql.html

    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 6, 2013 at 10:42 am

    #1639024

  • RE: Are the posted questions getting worse?

    Susan Cooper's The Dark is Rising series.

    Over Sea and Under Stone

    The Dark is Rising

    Greenwitch

    The Grey King

    Silver on the Tree

    The six tokens in the form of a cross in a circle...

    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 6, 2013 at 10:29 am

    #1639018

  • RE: Attach MDF that wasn't cleanly shutdown

    NickBalaam (8/6/2013)

    A. Is it possible to recover this database from the remaining mdf file (assuming no full backup exists)

    Maybe.

    B. If so, how?

    http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    However if you're working on a DR plan, 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

    August 6, 2013 at 9:23 am

    #1638990

  • RE: DROP TABLE in Database Mirroring environment

    Yes

    Yes

    Mirroring copies the log records across and ALL data modifications in a database are logged.

    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 6, 2013 at 9:21 am

    #1638988

  • RE: Query on a shared and exclusive lock

    Eric M Russell (8/6/2013)

    Update locks are generally at page level, unless the UPDATE operation is covering a large number of pages and SQL Server escalates intent exclustive (IX) lock 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

    August 6, 2013 at 8:57 am

    #1638976

  • RE: select DISTINCT cost too high?

    Sarah Wagner (8/6/2013)

    You are using the Distinct in a sub-select in the where clause using IN, why use distinct at all? Whether you have 1 record that matches 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

    August 6, 2013 at 7:28 am

    #1638914

  • RE: select DISTINCT cost too high?

    Is that 79% cost of the DISTINCT a problem?

    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 6, 2013 at 6:39 am

    #1638895

  • RE: What happen to the redo queue?

    High performance is asynchronous, not synchronous. If you run mirroring in async then you must accept the possibility of data loss.

    And no, that's not how you do a manual failover....

    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 6, 2013 at 6:21 am

    #1638881

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/6/2013)

    Lately, I've gotten a lot of connection requests from people just trying to bump up their counts (who I don't know from boo), so I've gotten 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

    August 6, 2013 at 6:16 am

    #1638878

  • RE: What happen to the redo queue?

    If the principal fails and you have unsent log then it doesn't matter whether you go for automatic or manual failover, failing over manually won't magically make the unsent log...

    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 6, 2013 at 4:08 am

    #1638843

  • RE: Quotations around variable

    An expression ('abc' + @z) is not permitted as a parameter to a procedure. Parameter has to be variable (or another parameter) or a constant

    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 6, 2013 at 3:34 am

    #1638838

  • RE: RECONFIGURE inside trigger

    The only advice I can offer on that is don't do it. Find another solution. SOAP requests from SQL are not recommended, the OLE automation are fraught with problems and...

    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 6, 2013 at 3:19 am

    #1638834

  • RE: Page file best practices and memory upgrade.

    You don't need that much page file. SQL shouldn't be using the page file at all and all that's needed with crash dumps, except in rare circumstances are kernel 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

    August 6, 2013 at 3:09 am

    #1638831

  • RE: What happen to the redo queue?

    The redo queue is the queue of log records on the mirror, log records that have already been hardened on the principal and mirror and only need to be redone...

    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 6, 2013 at 3:07 am

    #1638830

Viewing 15 posts - 12,181 through 12,195 (of 49,552 total)