Microsoft recommends partitioning tables that are over 8 million records. The keys to partitioning a table is to make sure you pick a good column to...
It's been a while since I have used SQL 2000, but in general sql server is rather aggressive and will use all available resources. Is this a new...
What limitations are you concerned with? You can use .NET email, but I try to use scripts only for things that have no component in SSIS since...
I use existence checks wherever possible. They are a true/false which returns as soon as the check passes or fails.
Have you tried putting a unique index on the url field? A unique field is a unique field, and while it is more efficient to search through numbers...
Query results themselves do not get cached, but the qualifying pages do.
Breaking this up won't affect performance per se, as there is no real penalty for setting more than one column. There are other pieces of...
For that, you can do a quick check for the existence of the record. IF NOT EXISTS (SELECT * FROM YourTable WHERE URL = @URL) INSERT INTO...
Separate names with a comma.
