From where can you change the default port?

3 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

---

What is difference between materialized view and view?

0 Answers  

---

What is the query optimization statistics?

1 Answers  

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

Why Master database is required?

0 Answers   Abacus,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Explain the cursor lock types?

0 Answers  

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---