刚刚结束的SENIOR SQL SERVER DBA 面试# Database - 数据库
z*y
1 楼
To warm up: what is inner join what is out join, and cross apply
what is the benefit using stored procedure.
How to identify perf issue on stored procedure.
Have you use profiler to troubleshooting perf issue of stored procedure, if
so what are those events you monitored
explain me what is lock
explain me the overview of replication, (bonus: Do you know the difference b
/t eager replication and lazy replication?_
What is trigger, any special thing you need be aware of in replication
environment.
what is the benefit using stored procedure.
How to identify perf issue on stored procedure.
Have you use profiler to troubleshooting perf issue of stored procedure, if
so what are those events you monitored
explain me what is lock
explain me the overview of replication, (bonus: Do you know the difference b
/t eager replication and lazy replication?_
What is trigger, any special thing you need be aware of in replication
environment.