SQL Server Performance

Log in or Sign up

Search Results

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...
How do I delete INVERSE duplicates (on two columns) from a really big table without the operation timing out?

Post by: bostondevin, Oct 14, 2008 in forum: SQL Server 2005 General DBA Questions

THAT WORKED!!!! YOU DA BOMB!!!!!!!!!!! It didn't blow up the log file either! [H]
How do I delete INVERSE duplicates (on two columns) from a really big table without the operation timing out?

Post by: bostondevin, Oct 11, 2008 in forum: SQL Server 2005 General DBA Questions

Hi! Thank you for responding! I'm trying both of these queries and they work great as SELECT statements, but I get errors as DELETE statements. For...
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 4 of 4