search

farzinmonsef / testNEW

0 stars 0 forks source link

SQL - Q & A #2

Open farzinmonsef opened 8 years ago

farzinmonsef commented 8 years ago

Select * FROM (SELECT ROW_NUMBER() OVER (PARTITION BY ID ORDER BY [FieldName] desc) RN,* FROM TableName (NOLOCK) WHERE SOURCE = 'ABC') A WHERE RN = 1 order by FieldName

farzinmonsef commented 7 years ago

Hi Farzin, please find below some of the topics that you might want to know specifically

Q1. Diff isolation levels in SQL server? Q2. Real times scenarios to go with Isolation levels? Q3. Explain concepts of table type values of SQL server? Q4. Ever used common table expression? Q5. Locking in SQL server? Q6. When will locking happen and precautions? Q7. How is security implemented in SQL Server? Q6. How many types of authentication SQL server has? Q7. Various components in SSIS? Q8. Issues when importing data from Oracle Server in SQL server? Q9. How to compare information in 2 excel files column by column? Q10 . have you used import export? Q11. How to Dev code from Env1 to env2? Q12. Unit Test a stored procedure? Not answered Q13. Source controls used for a SQL server code? Q14. Different Functions in SQL server? Q15. Triggers in SQL server?

Best Regards, Srihari Balakrishnan Desk #212-647-4918