What is best institute to Learn DotNET And SQL in chennai?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

Explain sub-query?

0 Answers  

---

Define compound operators?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

What is the recovery model?

0 Answers  

---

Can we shrink data file in sql server?

0 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

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

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

Mention the different authentication modes in sql server.

0 Answers  

---