Answer Posted / veerreddy

clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.

other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes

Where the sql logs gets stored? : sql server database administration

915

---

Explain what is the purpose of sql profiler in sql server?

1009

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

883

---

What is the federation in sql azure?

95

---

What is merge join?

1124

---

What are page splits? : SQL Server Architecture

935

---

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

920

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

992

---

Explain about temporary stored procedure?

934

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

971

---

How can I check that whether automatic statistic update is enabled or not?

985

---

Equi join and non equi join is possible with sql server?

937

---

Do you know what is a trace frag? Where do we use it?

955

---

how to use DTS package in 2000,2005,2008 in sql server

1786

---

What is bcnf normalization form?

1064

---