Answer / vidhya sagar

Self mapping
Delegation
Remote Credentials

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

---

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

0 Answers  

---

Explain how to use linked server?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

Does partitioning ssd reduce performance?

0 Answers  

---

explain the storage models of olap? : Sql server database administration

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---