Forum Replies Created

Viewing 15 posts - 35,716 through 35,730 (of 49,552 total)

  • RE: Performance issues related to Index

    devesh.v19 (11/20/2009)

    In reality I have over 10-15 of columns per table and I have over 30 of such tables in the database. Unfortnately the primary key indexing was done on...

    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 20, 2009 at 5:48 am

    #1082131

  • RE: Bloated Transaction Log

    That's a temporary fix. The create and drop publications is needed for a permanent fix if this is what I think it is (an imprperly cleaned up transactional replication publication)....

    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 20, 2009 at 5:37 am

    #1082126

  • RE: Can this query be improved?

    DISTINCT TOP 100 PERCENT .... ORDER BY????

    Is the distinct really necessary?

    Why the top 100 percent?

    Please post table and index definitions.

    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 20, 2009 at 1:53 am

    #1082026

  • RE: Primary Key vs Clustered Index - Very newbie question

    Carolyn Stern (11/19/2009)

    Now I think I discovered that if there is a primary "KEY" defined - and there is, then this becomes a clustered index. That's what I just...

    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 20, 2009 at 1:49 am

    #1082025

  • RE: Performance issues related to Index

    Well, when you run that the table will be unavailable until that has completed. Is that what you were asking?

    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 20, 2009 at 1:45 am

    #1082022

  • RE: Introduction to Indexes

    Douglas Osborne-456728 (11/19/2009)

    The question is, not is it necessary to have the primary key specified in indexes, but is it redundant?

    I'm obviously explaining badly.

    What columns the primary key is on...

    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 20, 2009 at 1:39 am

    #1082019

  • RE: Question on Filegroups, that I think I know the answer too...

    CirquedeSQLeil (11/19/2009)

    When filling space in the files, SQL uses a round-robin method - fill one file then move to the next and then the next, before growing any files.

    That's 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

    November 20, 2009 at 1:32 am

    #1082013

  • RE: Date and Time Issue in script - removing time and leaving date only

    http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/

    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 19, 2009 at 1:13 pm

    #1081817

  • RE: Introduction to Indexes

    Douglas Osborne-456728 (11/19/2009)

    Ok - so those indexes which have the PK attached to them are fine if they end up being covering indexes?

    It has nothing to do with the primary...

    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 19, 2009 at 1:11 pm

    #1081816

  • RE: Can SQL 2000 with Simple recovery model Can SQL 2000 with Simple recovery model participant in Backup and Recovery of Snapshot transaction replication

    Then you just can't use the 'sync with backup' option. The replication itself will work.

    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 19, 2009 at 1:10 pm

    #1081815

  • RE: UPDATE STATISTICS failed with table name containing score symbol '-'.

    UPDATE STATISTICS dbo.[db_log_pt-BR]

    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 19, 2009 at 1:07 pm

    #1081810

  • RE: ROW size is more than 8090 bytes

    Post the table definition

    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 19, 2009 at 1:06 pm

    #1081809

  • RE: Introduction to Indexes

    Do you have queries that filter on the combination of SSN + MyDataID or City + MyDataID?

    p.s. That's a poor choice for a clustered index. See part 2 of 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

    November 19, 2009 at 1:00 pm

    #1081806

  • RE: Bloated Transaction Log

    Kwisatz78 (11/19/2009)

    If so how do I resolve this?

    Providing there is no existing transactional replication publication....

    Create a new transactional replication publication.

    Run sp_repldone in the published database

    Drop the newly created publication.

    Run...

    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 19, 2009 at 12:58 pm

    #1081803

  • RE: Introduction to Indexes

    There's a discussion on whether a nonclustered index should explicitly contain the clustering key in the discussion for part 3 - http://www.sqlservercentral.com/Forums/Topic819337-1390-1.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

    November 19, 2009 at 8:21 am

    #1081593

Viewing 15 posts - 35,716 through 35,730 (of 49,552 total)