What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

What are the types of indexes?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

what is hash nonclustered index

0 Answers  

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What are sql dirty pages?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---