Entity Data Services in sql server 2008

Describe Entity Data Services in sql server 2008, i.e. Line Of Business (LOB) framework and Entity Query Language (eSQL)

SQL Server 2008 allows objects to be created for high level business like Customers, Parts, Inventory. Instead of returning individual rows and tables, these entities could be used. The E-R model will now match with the SQL model.
MERGE in sql server 2008
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition..........
Steps to improve performance of a poor performing query
Steps to improve performance of a poor performing query - Maximum use of indexes, stored procures should be done, Avoid excessive use of complicated joins and cursors........
Deadlock and live lock. How will you go about resolving deadlocks?
Deadlock and live lock - A deadlock occurs when two or more processes waits for a resource that is acquired by or is under the control of another process.....
Post your comment