Jeff Moden (12/17/2010)

Please post the test code....

I'm working in linked server but you might be working in your own. i just told it based upon the average of ten times but i would like to convey...

by the by,.... current_timestamp averages 0.21 seconds where as getdate() averages 0.234 seconds.

I've checked elapsing time for each of those and got approximate time is less for current_timestamp than getdate().

Is current_timestamp better? i think so....

NewBie you are and No Comments. I hope you just finished your MBA this year.

Its purely inner join with "case when" condition.

column should be fetched from primary table when there is no record available for that vehicleGUID in battery table, otherwise you just need...

Please go with the enddate column in the table rather than calculating it separately. This is less pain to database and also it will give fast retrieval.

Sorry, its quite confusing me. Could you elaborate in detail?

Questions

A) Should I create a new database for product line B? A salesrep may work on both product line A and product line B, so as a user who may...

Questions

1) Instead of having Default value on column, insert explicitly default value.

2) Keep column constraint as NULL(Eventhough it ll not have NULL at any time) & explicitly take care in...

Use execution plan to monitor which is first binding and order of joins. Naturally it will join based upon the order you have given but still based upon the primary...

thanks buddy. you are correct its across databases, where as i need schema binding in view not in table which is my original query.

I've already used like that, but i need it across databases.

Thanks for the reply...

For example i've two databases called "dbFirst" and "dbSecond".

In dbSecond i've a table called "EmployeeTable".

I'm going to create a view called "EmployeeView" in dbFirst database with

Select

...

I would like to use getdate() mostly as its having frequent hits than current_timestamp. So far i couldnt see any objections with getdate() and its user friendly.