If I have a table with nine fields, 7 are int and 2 are datetime, how many rows is it likely to handle before it starts to slow up a bit?

Just curios to what different peoples opinions might be?

Tables don't get slow...

Queries that retrieve the data are the things that take time.

So if for example there are 800,000 (or more) rows in a table and I have a query that is pulling back the values of 3 or 4 rows based on a specific where clause would it still be as quick if there were only 1,000 rows?

if the query is making use of indexes to restrict the rows returned yes, if it requires a table scan no (ie it has to search through every row to find the data)....