Trash Talk - SQL Query Comparison i88gerbils - Wed Mar 08, 2006 12:54 pm Post subject: SQL Query Comparison
I ran this query in both SQL Enterprise Manager and MSDE Query:
DELETE FROM XXXXXXXRequiredProperties
WHERE MessageClass LIKE '%Activity%' FolderID = '{8507cbf7-e9bd-11d1-aec5-00a024fdf47f}'
Basically parsing 360k+ records. However, ODBC timed out on SQL Enterprise Manager yet the query ran just fine in MSDE Query.
I guess this is a lesson. If you want to DELETE lots of records (not the whole table), then you'll probably want to avoid using SQL Enterprise Manager or an ODBC's SQL Server module.