Answer / sqldba29

Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts

1204: Deadlock information

what is a join? : Sql server database administration

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

Explain concepts of analysis services?

0 Answers  

---

What is a transaction and why is it important?

0 Answers  

---

---

What is normalization and denormalization in sql server?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

What is an extended Stored Procedure?

1 Answers  

---

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

Can select statements be used on views in ms sql server?

0 Answers  

---