How to delete duplicate rows from table except one?
Explain what are various ways to enhance the ssrs report?
What are points to remember while using the fillfactor argument?
How to update muliple row in single query?
How to set database to be read_only in ms sql server?
What is transaction server consistency?
Do you know what is difference between stored procedure and user defined function?
When we should use and scope of @@identity?
If the job running very slow what is the action you do
What is built-in/administrator?
Can you roll back the ddl statement in a trigger?
Explain “row_number()” in sql server with an example?
Does table partitioning improve performance?