Answer Posted / hari

Windows authentication is more securable compare to mixed
mode authentication.

What do you mean by an execution plan?

1050

---

Differentiate between sql temp table vs table variable?

827

---

What are the properties and different types of sub-queries?

955

---

How much space does sql server 2016 take?

908

---

Explain the etl (extraction, transformation, and loading)?

934

---

How to create a simple user defined function in ms sql server?

963

---

How to change a login name in ms sql server?

1023

---

What happens when unicode strings concatenate with non-unicode strings?

998

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

956

---

Do you know what is lock escalation?

963

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1007

---

What is dbcc updateusage?

1148

---

Explain few of the new features of sql server 2008 management studio

858

---

Why use update_statistics command in sql server?

994

---

What is ms sql server reporting services?

988

---