Answer Posted / anil kumar

Here's the procedure:

Create a table with no primary key defined.
Create clustered index on the primary key columns.
Alter the table to define the primary key.

Table creation:

create table CDSWEB.Anil (officeid integer not null,
empid integer not null,
age integer ,sex varchar(5),
name varchar(20));

Index creation:
create index CDSWEB.AN001 on CDSWEB.Anil(officeid,empid)
CLUSTER;

Primary key defined:

alter table CDSWEB.ANIL
add primary key (officeid,empid);

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

962

---

Explain how to integrate the ssrs reports in application?

1006

---

What is 3nf normalization form?

1102

---

How do I view a procedure in sql server?

984

---

How do I debug a stored procedure in sql server?

1093

---

What is order of B+tree?

1102

---

Can one drop a column from a table?

1012

---

what's the difference between a primary key and a unique key? : Sql server database administration

935

---

In what three ways is the return statement used in a stored procedure?

1000

---

Name 3 ways to get an accurate count of the number of records in a table?

1020

---

Can you explain what are various ways to enhance the ssrs report?

996

---

What is sql service broker?

972

---

Which tools are available to manage SQL Azure databases and servers?

115

---

How will you find out if there are expensive SQL statements running or not?

1007

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1039

---