Forum Replies Created

Viewing 15 posts - 36,121 through 36,135 (of 49,552 total)

  • RE: Introduction to Indexes

    lharmes (10/26/2009)

    In other words, if my key is lastname + firstname, my query would need to be SELECT * FROM Names WHERE LastName + FirstName LIKE 'Smith%'. Is 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

    October 26, 2009 at 2:53 pm

    #1070942

  • RE: Can't connect to a cluster instance because of a problem with a LOGON trigger (Error 17892)

    Go into cluster admin and shut the SQL instance down. Make sure it doesn't try to restart.

    Open a command prompt. Navigate to the directory where the SQL executable is 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

    October 26, 2009 at 2:29 pm

    #1070926

  • RE: Introduction to Indexes

    jbuttery (10/26/2009)

    Perhaps you could cover statistics one day and how they relate to indexes.

    Next week Thursday, 4pm Seattle time.

    http://summit2009.sqlpass.org/Agenda/SpotlightSessions/Liesdamnedliesandstatistics.aspx

    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

    October 26, 2009 at 2:19 pm

    #1070921

  • RE: Introduction to Indexes

    SQL Noob (10/26/2009)

    is there any hard documentation on what the tipping point is for an index seek to become an index scan? is it 5% of rows affected, 10% 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

    October 26, 2009 at 2:13 pm

    #1070917

  • RE: Actual Query Plan - Actual Row Count massively exceeds Est Row Count

    allen davidson (10/26/2009)

    I already have a covering index on tblCustomers

    CREATE NONCLUSTERED INDEX [IX_EmailAddress] ON [dbo].[tblCustomers]

    (

    [emailaddress] ASC,

    ...

    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

    October 26, 2009 at 2:09 pm

    #1070911

  • RE: Transaction logs are big

    Please read through this - Managing Transaction Logs[/url]

    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

    October 26, 2009 at 10:26 am

    #1070812

  • RE: Whats the best way to rebuild both cluster and non cluster indexes

    Per Books Online

    ALL

    Specifies all indexes associated with the table or view regardless of the index type. Specifying ALL causes the statement to fail if one or more indexes are 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

    October 26, 2009 at 10:26 am

    #1070811

  • RE: Actual Query Plan - Actual Row Count massively exceeds Est Row Count

    allen davidson (10/26/2009)

    The part of the execution plan that looks suspicious (to me) is the clustered index scan of tblCustomers. In the good plan actual rows = estimated rows 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

    October 26, 2009 at 9:32 am

    #1070779

  • RE: Introduction to Indexes

    SanjayAttray (10/26/2009)

    "When an index scan is done on the clustered index, it’s a table scan in all but name."

    Then why do we see index scan and table scan separately 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

    October 26, 2009 at 9:13 am

    #1070760

  • RE: Possible deferred transaction

    The log can only be truncated up to the beginning of the oldest active transaction. If you're trying to insert an entire (large) table, then that will run as 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

    October 26, 2009 at 8:13 am

    #1070713

  • RE: Who is going to the PASS Summit 2009?

    WilliamD- (10/26/2009)

    are you flying Air France by any chance? I have pretty similar times for my flight from Paris to Seattle.

    Air France/KLM. Stopping in Paris on the way there,...

    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

    October 26, 2009 at 8:08 am

    #1070711

  • RE: Optimizing Queries: Disadvantages of using Temp Tables?

    huston.dunlap (10/26/2009)

    One thing I have found hugely successful so far is breaking down large queries into Temp Table work and then manipulating those tables (especially to get away from subqueries).

    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

    October 26, 2009 at 8:03 am

    #1070709

  • RE: SQL 2008 database in recovery for 22+ hours!!!?

    It's something to worry about. IO errors are always something to worry about. Will see if I can pass this on to someone who will know the details of 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

    October 26, 2009 at 7:50 am

    #1070701

  • RE: Who is going to the PASS Summit 2009?

    Ha ... Ha ... Ha ....

    Leaving Friday evening. Breakfast Saturday morning in Paris, arrive in Seattle around 1pm Saturday afternoon.

    21 or so hours of flying, 4 hours layover. Had better,...

    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

    October 26, 2009 at 7:47 am

    #1070698

  • RE: Actual Query Plan - Actual Row Count massively exceeds Est Row Count

    A plan will never warn of out of date stats, only of missing stats. Does manually updating the statistics fix the problem?

    Very likely parameter sniffing. Check out this short series....

    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

    October 26, 2009 at 6:50 am

    #1070654

Viewing 15 posts - 36,121 through 36,135 (of 49,552 total)