GilaMonster,

Thanks for your help. After all reading, I think I will add the OPTION RECOMPILE to the inline function combined query or even convert it to a stored procedure with...

Thanks for your answer!

I ve read the article carefully and it illustrates very well the case.

But the difference for my query is that it resides in an Inline Table Valued...

Thanks, they seems to me valid reasons!

Thanks for your opinion!

Which advantages do you see in separating the exceptions and error logging to a different database?

Regards!

Thanks for your help!

Sorry, I clicked enter before ending writing and I didn't realize... :s

HowardW - Thanks for your tip!

Lynn Pettis

Will this:

WHERE cast(DateColumn as DATE) = cast(@DateToFind as DATE);

perform better than this?

WHERE...

HowardW - Thanks for your tip!

Lynn Pettis

Will this

cast(DateColumn as DATE) = cast(@DateToFind as DATE);

HowardW, thanks for your explanation!

You've confirmed my thoughts.

Another question, (sorry for join two questions in one topic)

Instead of a datetime, if I cast a string with format 'yyyy-MM-dd',

will this cast...

Hi!

I ended up using rowversion, since it was not enough to compare the old and the value in the table column before the column update.

Other columns values may have changed...

Thanks for all your opinions.

I think I really just need to check the value of the column to update before I update it.

Regarding rowversion:

If I add rowversion to a table...

It is a good point also!

In my case the tables with static data will mostly not change.

I have been using the extended properties to document the tables, but the table...

Grant,

Many thanks for your opinion!

Thanks for your suggestions!

I think i will go with the distinct schema for the static data.

Best Regards!

Hi!

I use this free tool 'dbcomparer' to compare dev and live databases and get the changes. Then I use SQL Server to 'Generate Scripts'

Regards

Thanks!