Forum Replies Created

Viewing 15 posts - 35,926 through 35,940 (of 49,552 total)

  • RE: Trouble with Distinct in SQL2000

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 11, 2009 at 9:09 am

    #1077869

  • RE: Understanding some locks appearing in dead locks

    siddartha pal (11/11/2009)

    Should I go and create all these recommended indexes?

    Test the suggestions carefully first. If they help, create them, if they don't then don't create them

    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 11, 2009 at 9:08 am

    #1077866

  • RE: Understanding some locks appearing in dead locks

    siddartha pal (11/11/2009)

    Could you please let me know how to check connection setting in profiler?

    The audit login event. The textdata column will give the isolation level (as well 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

    November 11, 2009 at 9:04 am

    #1077865

  • RE: Resetting the default isolation level

    Consider read-committed snapshot, just watch the impact on TempDB.

    It's not just dirty reads that read uncommitted allows. It can result in rows missed in a scan or rows read twice...

    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 11, 2009 at 9:02 am

    #1077863

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

    SQL Noob (11/11/2009)

    if i have a table with a clustered index and say 5 NC indexes

    i run alter index <clustered_index> on <some_table> rebuild

    will this also rebuild all the non-clustered 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 11, 2009 at 8:53 am

    #1077858

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

    Esalter (11/11/2009)

    If an identity column is used for the clustered index (CI) and NC indexes use the identity column (key) rather than a RID as the retrieval pointer then doesn't...

    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 11, 2009 at 8:46 am

    #1077855

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

    Esalter (11/11/2009)

    one thing I've frequently come across that would be extremely useful is the ability to define Foreign keys that are a compound key (concatenated columns). Do you know if...

    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 11, 2009 at 8:43 am

    #1077852

  • RE: Resetting the default isolation level

    No and no. The default isolation level for SQL is read committed. It's not a database level setting that can be defined on creation of a DB. If you're connecting...

    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 11, 2009 at 8:35 am

    #1077843

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

    Brian.Eriksen (11/11/2009)

    Anyways, I just thought that since summary-detail table relationships are very common that it's probably worth calling out this exception to the uniqueness guideline specifically. What do you think?

    Those...

    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 11, 2009 at 8:32 am

    #1077840

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

    Esalter (11/11/2009)

    I'm surprised that non clustered indexes don't also use the RID to provide a more efficient use of space.

    A RID is 8 bytes. An integer column defined as identity...

    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 11, 2009 at 8:24 am

    #1077831

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

    TheSQLGuru (11/11/2009)

    I am often-times disappointed that I cannot have more than one clustered index. Do you think they will ever put this most useful feature in SQL Server Gail??...

    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 11, 2009 at 8:17 am

    #1077824

  • RE: Understanding some locks appearing in dead locks

    siddartha pal (11/11/2009)

    Yes, we are not changing any isolation level in code.

    Well something is setting the isolation level to serialisable. I think you need to find what it is. Check...

    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 11, 2009 at 7:57 am

    #1077798

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

    talltop-969015 (11/11/2009)

    Hmmm, the link is there at the bottom of Part 2 though.

    Yes it is. Steve added the links, probably so that he wouldn't have to repeatedly edit 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

    November 11, 2009 at 7:01 am

    #1077767

  • RE: Transaction Log out of control

    Is there supposed to be any transactional replication set up? Are there any transactional replication publications?

    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 11, 2009 at 6:49 am

    #1077754

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

    talltop-969015 (11/11/2009)

    Unfortunately, I was not able to read Part 3 as of yet since there seems to be an error on the web page.

    That's because it hasn't been...

    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 11, 2009 at 6:48 am

    #1077753

Viewing 15 posts - 35,926 through 35,940 (of 49,552 total)