Answer Posted / vishnu

SQL Server

Is it important for a database administrator to understand the operating system and file access?

965

---

Explain what is the main purpose of having conversation group?

918

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1031

---

What are the basic functions for master, msdb, model, tempdb databases?

1024

---

How can you find out which stored procedures are recompiling?

909

---

What is bcp? When does it use?

918

---

What is difference in performance between insert top (n) into table and using top with insert?

1019

---

Define master database?

1041

---

How to convert numeric expression data types by assignment operations?

1053

---

Can I disable or restrict ssrs export formats (rendering formats)?

148

---

How to use subqueries in the from clause in ms sql server?

1145

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2129

---

What is server-level principal?

122

---

when you create a database how is it stored? : Sql server database administration

997

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

962

---