Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    65

    Unanswered: One table is ultra slow at being copied, others are fine

    This is a really really odd problem.

    Here's the situation. I've got a DB with several tables. Let's pick out two of those tables from the bunch.. they both have approx 2500 rows in them. I take one and duplicate it (right click, All Tasks->Export Data, copy tables, etc) and it duplicates just fine into another DB.

    Now, the second table.. takes FOREVER. Yet it has the same amount of rows in it! And this is a flat table export.. I'm not including dependent objects or anything like that.

    Not to mention this is slow, but when I use Red-Gate SQL Data Compare, it gets stuck when it hits this specific table.

    Anyone have any idea what would cause this?

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    difficult to guess... u can run profiler and get the sqls to check where it is getting stuck...

  3. #3
    Join Date
    Jan 2004
    Posts
    65
    Profiler eh? Is this some tool that comes w/ SQL Server 2005? Let me know.. I'll have to check into this.

  4. #4
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    profiler is there with sql 2000 and 2005. when running it captures various activities happening under the hood.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •