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

0 Answers  

---

What is nonclustered index on computed columns?

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

Can we add an identity column to decimal datatype?

0 Answers  

---

What is a transaction and what are ACID properties?

3 Answers  

---

Does group by sort data?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

Can two tables share a primary key?

0 Answers  

---