Answer / swapna

User defined datatypes let you extend the base SQL Server
datatypes by providing a descriptive name, and format to
the database. Take for example, in your database, there is
a column called Flight_Num which appears in many tables. In
all these tables it should be varchar(8).

In this case you could create a user defined datatype
called Flight_num_type of varchar(8) and use it across all
your tables.

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

What is nested transaction?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

What are sparse columns?

0 Answers  

---

What is set nocount on?

0 Answers  

---

What is a view in sql?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How do I partition a table in sql server?

0 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---