Forum Replies Created

Viewing 15 posts - 40,726 through 40,740 (of 49,552 total)

  • RE: Indexs - Misunderstanding or abnormality?

    That'll say index seek but, behind the scenes it's almost equivalent to an index scan.

    Seek to find the start of the range for column 1 - the beginning of 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

    February 27, 2009 at 1:51 am

    #951022

  • RE: help

    Are the tables in Access or are they in SQL 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

    February 26, 2009 at 5:14 pm

    #950909

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/26/2009)

    Didn't get me to the page where we discussed it, but it gets to the thread

    I can find the thread just fine, all 200 pages of it!

    I think...

    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

    February 26, 2009 at 4:35 pm

    #950896

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (2/26/2009)

    Bob Hovious (2/26/2009)

    Sheep without a shepherd are prone to wander....

    I'm just glad we have a consistent URL and I don't need to Google for this. Not...

    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

    February 26, 2009 at 4:11 pm

    #950889

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/26/2009)

    All SQL Keywords in UPPER CASE.

    All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase with no underscores. ...

    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

    February 26, 2009 at 1:44 pm

    #950826

  • RE: Help Performance Tune this Code please

    GSquared (2/26/2009)

    That's why I suggested trying a check constraint on the date range in each table, which will let the server know that there's no overlap. Not sure...

    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

    February 26, 2009 at 12:40 pm

    #950775

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/26/2009)

    At least the first post hits the high points and keeps you up to speed.

    Yup. Half way through and I was reaching for my books. I really enjoyed...

    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

    February 26, 2009 at 12:18 pm

    #950763

  • RE: Help Performance Tune this Code please

    GSquared (2/26/2009)

    CREATE NONCLUSTERED INDEX [IX_NONCLUSTERED_ORDER_BY_KEYS_PersonURN_200901] ON [dbo].[PersonURN_200901]

    (

    [ServiceDate] DESC

    [Client_id] )

    INCLUDE

    (

    ...

    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

    February 26, 2009 at 12:14 pm

    #950760

  • RE: Are the posted questions getting worse?

    While following links from that, I ran across this: http://www.tor.com/index.php?option=com_comprofiler&task=searchByTag&tag=Wheel%20of%20Time%20re-read

    A re-read and summary of the entire Wheel of Time, reducing each chapter to what looks like 500-700 words. At 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

    February 26, 2009 at 11:13 am

    #950733

  • RE: Update statment

    Look up the function REPLACE in Books Online

    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

    February 26, 2009 at 10:13 am

    #950708

  • RE: optimization help

    Lynn Pettis (2/25/2009)

    Someone want to explain what the statistics profile is saying?

    Each line in the stats profile corresponds to an operator in the query. If it were 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

    February 26, 2009 at 10:10 am

    #950706

  • RE: Indexs - Misunderstanding or abnormality?

    Fraggle (2/26/2009)

    Gila,

    If that is the case and I am getting a filter on column 6, then why does the exection plan say

    Index Seek -> Select

    with no filter 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

    February 26, 2009 at 9:29 am

    #950678

  • RE: Urgent!! How to ImproveLOG Shipping performance in SQL Server 2005 ?

    cshekhar (2/26/2009)

    And after this we have scheduled COPY, BACKUP for 2hrs and RESTORE for every 4hrs respectively. By this also we are unable to improve the performance ! this was...

    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

    February 26, 2009 at 9:24 am

    #950676

  • RE: Sql server 2005

    Please post in an appropriate forum in the future. The article discussion forums are for discussions on articles.

    Google will give you links to quite a few apps that can...

    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

    February 26, 2009 at 9:20 am

    #950672

  • RE: Attached Database Without LDF

    aks_pra (2/26/2009)

    I wanted to Attached database without LDF file.

    B’coz my LDF size is greater than the MDF

    That is a very, very bad way of handling a large transaction 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

    February 26, 2009 at 9:16 am

    #950668

Viewing 15 posts - 40,726 through 40,740 (of 49,552 total)