What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

What do you understand by coalesce in sql server?

0 Answers  

---

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---

Explain DBMS, RDBMS?

6 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

What is the difference between locking and multi-versioning?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---