how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

What are subqueries in sql server?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What are the different type of replication in sql server?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

---

How do I open port 1433?

0 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

When we should use and scope of @@identity?

0 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---