what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

0 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

What is normalization and denormalization in sql server?

0 Answers  

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

What is shrink log file?

0 Answers  

---

Can a rule be bound to any column of any data type?

0 Answers  

---

What is pivot and unpivot?

0 Answers  

---

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

1 Answers  

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---