It IS a balancing act, but starting with the attitude that FK's are worthless (which is what you're not just portraying - it's like you're screaming it from the rooftops)...

prattmounfield (11/19/2007)

---

In back-to-back test, I found the following with SS V7 (I know a while back but probably still valid): No RI is the fastest (of course); RI enforced by...

pdross2000,

You are correct that you cannot truncate a table with a foreign key and that it may make spot restoring tables a bit more difficult but you are placing...

Well, I would wait longer than 15 minutes and see what happens. Don't trust the progress messages, just wait a bit and see what happens. It will take...

The problem is that this attitude will force the existence of those spreadsheets/access databases/word files full of data that should be in the database but can't be entered because it...

OK, I think what you want is to find the values that correspond to the smallest YearValue for each Value. If this is correct, something like the following code...

It is not quite clear what you are asking for. Can you give a written description of what you want to get back? Also include the result set...

Yes, just as Adam said, create a linked server and then run the query using the 4 part names. As for the query, you are looking for rows that...

There shouldn't be data to fix if the application is truely handling referencial integrity. The mere fact that this is a concern tells me that you have the illusion...

Whoa, hold on here my friend. How are you comming to your first end date? There is no 14th month! I thought from your original post that...

SQL Noob (11/14/2007)

---

there are no good and bad or black or white in SQL, only gray areas and what is good for your situation

we have very few FK's where i...

Well first of all, any time you run a 'SELECT *' you get a full table scan. Your query plan shows a clustered index scan but in this case,...

Please do not cross post. You only need to post your question in one forum!! Continue this thread here:

http://www.sqlservercentral.com/Forums/Topic422446-8-1.aspx

What exactly are you looking for? Do you want to select rows that are different in the 2 tables? Are the databases on the same server or not?

Please do not cross post. Continue this thread here:

http://www.sqlservercentral.com/Forums/Topic422446-8-1.aspx