Answer Posted / murtaza

INDEXES:
1.indexes are used for performance as well as query
optimization issues in database.
2.indexes are by default created when u create an primary or
unique index on a particular column in a table.
3.In sql server there are 2 types of indexes
1.clustered index
2.non clustered index
4.By default non clustered index are created in sql server 2005.
WHEN TO CREATE INDEXES:
1.indexes should be created on the tables which will be used
frequently.
2.it should be created on d tables which has large amount of
data.

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1152

---

What are drilldown reports?

160

---

What are the features of Embedded SQL

1175

---

How to create user defined functions with parameters?

1298

---

Explain can SSRS reports Cache results?

161

---

where the connection string store in the database

2124

---

Can you type more than one query in the query editor screen at the same time?

1069

---

Describe the left outer join & right outer join. : sql server database administration

1037

---

How to edit table in sql server 2017?

982

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1941

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

1038

---

How dts is used to extract, transform and consolidate data?

1116

---

What do you mean by recursive stored procedure?

993

---

How to link tables in sql server?

976

---

List some advantages and disadvantages of stored procedure?

1063

---