Answer Posted / simi

yes,
CREATE TABLE [dbo].[custrate](
[id] [int] NOT NULL,
[patname] [char](50) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rate] [int] NULL,
CONSTRAINT [PK__custrate__12FE9D09] PRIMARY KEY CLUSTERED
(
[id] ASC,
[patname] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

How to view existing indexes on an given table using sys.indexes?

1151

---

What do you mean by an execution plan? Why is it used?

1075

---

How does using a separate hard drive for several database objects improves performance right away?

988

---

how to define testing of network layers? : Sql server database administration

1020

---

How to use “drop” keyword in sql server and give an example?

1193

---

How do you trace the traffic hitting a sql server?

1189

---

Does full backup break log chain?

1013

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

1050

---

What is the difference between resultset and resultsetmetadata?

1030

---

What is database mirroring?

1175

---

How to find the version of sql server? : sql server database administration

1163

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

977

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1031

---

Do you know what are the reporting services components?

1020

---

Can we use custom code in ssrs?

1165

---