What is filtered index?
No Answer is Posted For this Question
Be the First to Post Answer
What are policy management terms?
What are the different types of subquery?
What is the recovery model? List the types of recovery model available in sql server?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?
Explain what is cte (common table expression)?
Explain the truncate command? : SQL Server Architecture
What are explicit and implicit transactions?
How to delete an existing database user?
What are built in functions?
What are synonyms?
what is a join? : Sql server database administration