Ok... First of all sorry for being late to review the answers and i know that Jacob has set a wrong precedence(sorry jacob.. :) just joking sir.. ) by giving proper reasoning for each score. But i beg your pardon and i am not doing that. Reason being...

Can a constraint help optimizer to get optimized plan and there by better performance? If Yes explain with a scenario...

The set options can also make the SP recompile... You may want to refer this article for various reasons for recompilation and how to eliminate/reduce http://technet.microsoft.com/en-us/library/cc966425.aspx...

Few more points... Log file is never part of filegroup. And this kind of READONLY data in a seperate file group for backup will work only in Enterprise edition. So do you have that edition? Another very common consideration for filegroup is, Create all ...

Did you find a method to handle this? One dirty method would be Create unique index with WITH IGNORE_DUP_KEY . See the example below. Another method would be writing a Instead of Insert trigger and if exists ignore kind of... You may want to try that a...

We have a server (windows 2003 64 bit EE) where both sql server 2008 and Oracle 11 G is running. I dont know whether it works on windows 7 but as such it can co-eixits on the same server provided u have enough resources....

Using Indexed view in SQL Server comes with a cost. But there are places which it perfectly fits in and at the same time there are places where it create problem than solution. So, what all are the pros and cons of using Indexed...

When will you use a Surrogate Key and when will you use a Natural Key?...

<p>Can you check if SQL Server 2008 is already installed when you installed VS2010?</p> <p>Madhu</p>...