Answer Posted / suraj

-- YES.

drop table Employees
create table Employees(
EmpID int Primary Key NonClustered,
[Name] varchar(20),
SSNo varchar(20) )

CREATE CLUSTERED INDEX ci_EMPLOYEES_SS ON EMPLOYEES (Name)

insert Employees values (101,'John','123-45-6789')
insert Employees values (102,'Mike','123-45-6789')


select * from Employees

-- We have to specifically define NonClustered in the
Primary Key column because Clustered Index is created by
default in Primary Key.
-- And, We are able to define Clustered Index in
another column because every table is eligible to have one
clustered index.
-- Clustered Index has to be created after table
creation.
-- From above example, EmpID doesn't take duplicates,
because it is primary key. But, SSNo takes duplicates.

How do I view a procedure in sql server?

984

---

Difference between Logical Page and Physical Page in SSRS.

474

---

What are parameterized reports?

200

---

What are the transaction properties?

1004

---

whats the maximum size of view state??

2185

---

What stored by the model?

1045

---

Do you know what is fill factor and pad index?

996

---

What are the restrictions while creating batches in sql server?

1054

---

what types of replication are supported in sql server? : Sql server database administration

1032

---

Explain the relational database management system (rdbms)?

1081

---

What is named query? : sql server analysis services, ssas

954

---

What does the not null constraint do?

1070

---

What is the difference between primary key and unique constraints?

950

---

What are the advantages of using cte?

1004

---

What is sql server profiler trace data file?

1100

---