What is an execution plan? When would you use it?

0 Answers  

---

How make remote connection in database?

1 Answers  

---

Tell me what do we need queues in sql service broker?

0 Answers  

---

What are unicode character string data types in ms sql server?

0 Answers  

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

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  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

Can we drop user if user mapped to any logins

1 Answers  

---

what are three different authentications to connect linked servers?

1 Answers   CitiGroup,

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---