Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

Explain few of the new features of sql server 2008 management studio

0 Answers  

---

role of sql sever 2005 in database rather than any other database

0 Answers  

---

Explain time data type in sal server 2008?

0 Answers  

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

---

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

How will you decide the active and passive nodes?

0 Answers  

---

What are sparse columns?

0 Answers  

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is a partition function in sql server?

0 Answers  

---