What is query optimizer in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Which table keeps the locking information?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is an execution plan? When would you use it?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is a trigger what are the advantages of trigger?
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
How to delete the duplicate rows from a table in SQL Server ??
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to stop log file growing too big?
What are the essential components of sql server service broker?
What is an execution plan? When would you use it? How would you view the execution plan?
how to overcome kernel isssues