Answer Posted / samrat sen

Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.

How can a database be repaired?

989

---

what are the types of indexes? : Sql server database administration

1124

---

What is pessimistic concurrency?

976

---

When we should use @@error?

969

---

Where is my database stored on the hard disk in ms sql server?

1061

---

What are commonly used mssql functions in php?

1081

---

Which database stores information about replication?

1071

---

How to drop an existing table with "drop table" statements in ms sql server?

1086

---

What is the difference between update lock and exclusive lock?

976

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2010

---

Explain what is lock escalation?

1066

---

What command is used to create a database in the sql server and how?

1181

---

What is the difference between Stored Procedures and triggers?

1082

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

941

---