Explain filestream storage of sql server 2008?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

---

---

What are the different types of replication are there in sql server 2000?

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,

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

What is the difference between the application object and session object?

0 Answers  

---

How do I create a stored procedure in dbml?

0 Answers  

---