What stored by the tempdb ? : sql server database administration

0 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

what is Covering Index ?

3 Answers   Thomson Reuters,

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

---

What is the concept of optimization?

0 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

How to recover from sql injection? : sql server security

0 Answers  

---

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What types of replication are supported in sql server?

0 Answers  

---