SQL Server Performance

Search Results

Search Again
  1. bostondevin

    delete where a value does not exist in another table...

    Thread by: bostondevin, Oct 14, 2008, 8 replies, in forum: SQL Server 2005 General DBA Questions
    I have two tables (TableA, and TableB) and i'm looking to delete any records in TableA where the values of col1 or col2 do not exist as an id in...
  2. bostondevin

    How do I delete INVERSE duplicates (on two columns) from a really big table without the operation timing out?

    Thread by: bostondevin, Oct 9, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions
    This is a little had to explain, but i'll do my best. I have a large (300,000+ records) SQL table structured like this: id(auto) col1(int)...
Showing results 1 to 2 of 2
Search Again