Differentiate between a primary key and a unique key.

0 Answers  

---

How can I get data from a database on another server?

0 Answers  

---

What are the type of Indexes? which one is best, why?

6 Answers  

---

Name the different type of indexes in sql?

0 Answers  

---

Explain what are the different index configurations a table can have?

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   HCL, Wipro,

---

Is null vs coalesce?

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How do I get to sql server configuration manager?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

What functions can a view be used to performed?

0 Answers  

---