Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

What stored by the msdb?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

how to dispaly a particular row details from a given table

2 Answers  

---

What is amo? : sql server analysis services, ssas

0 Answers  

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

How do I find sql server instance name?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

How do you load large data to the SQL server database?

2 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

what is sql server? : Sql server database administration

0 Answers  

---