Hmmm - indexed views may be a good option in this case. Since the stored proc could be called concurrently by multiple users using different input...
Thanks for these suggestions. I like both ideas. Unfortunately in my case I can't (easily) modify the underlying table structures, create triggers,...
Consider a database with 2 large tables -- Book and BookLog. The Book table contains millions of book records and BookLog contains activity about...
I have a couple of questions about how to handle a basic/common scenario. Say you are developing a stored procedure that takes input parameters and...
I've got an import table that contains about 500k records of unencrypted data, and a target table with around 150 million rows of encrypted data. I...
Separate names with a comma.
