SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login

Home Forums SQL Server 2008 SQL Server 2008 Administration Trouble Dropping Primary Key RE: Trouble Dropping Primary Key

  • Ed Wagner

    SSC Guru

    Points: 287026

    More actions

    June 24, 2014 at 11:21 am

    #1724418

    Did you drop your nonclustered indexes first?

    For details on CXPACKET, Paul's blog on wait stats is at http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

    • About SQLServerCentral
    • Contact Us
    • Terms of Use
    • Privacy Policy
    • Contribute
    • Contributors
    • Authors
    • Newsletters
    Redgate logo