How to optimize stored procedures in sql server?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

Give an example of why you would want to denormalize a database

0 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---