The default is like 30 seconds.  It's already 30 times bigger than it needs to be.  So I'd suggest you improve the performance of the code instead of the length...

Assuming you actually need to use Dynamic sql (because you don't need to in your exemple) :

    EXEC sp_executesql @sql, N'@YourVariableHere INT OUTPUT', @YourVariableHere OUTPUT

I didn't know that.  You'll have to drop/recreate all the objects that the server complains about.

Please do NOT cross-post.  WE monitor all the boards all the time.

Please continue the discussion on this board : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=324&messageid=384251

A foreign key constraint cannot be applied if the Parent table does NOT have a unique constraint of any kind.  By removing the PK, you violate that rule.

Try this :...

Archive the inactive rows somewhere else.  Add a check constraint that Active must equal 1 and run that new constraint with check.

Also you can post the exec plan of that...

.  Thos error message are misleading sometimes .

You already have the right syntax for it.

The view will still have to scan the table.  Indexed view may be an option.  But this actually creates a second table.  I think I'd go with with separating the...

Hmm, what are you getting exactly, and what are you expecting to get?

I'm always curious for these things... which one is the fastest??

You got me on my curious side Sergiy, what is that other route you are talking about?

Since when is there a bad way to do something that works in sql server???

Granted that profiler seems like the best choice here .

This seems like an Orders / OrdersDetails schema.

Based on that assumption you need to do something like this :

SELECT O.ID, ISNULL(Dtd.SPrice, 0) AS SPrice FROM dbo.Orders O LEFT OUTER...

Let me put it this way.  I've seen this done before using sql server.  But the guy pretty much wrote a lite version of Excel.  So I'd try to find...