Answer Posted / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

What is the default schema of your login session in ms sql server?

991

---

How will you know when statistics on a table are obsolete?

1029

---

What is fill factor and pad index?

949

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

892

---

What is tempdb database? : SQL Server Architecture

1108

---

How to drop an existing user defined function in ms sql server?

979

---

What is openxml in sql server?

1104

---

What is implicit mode in sql server?

1027

---

What is sub query and its properties?

916

---

How to edit table in sql server 2017?

877

---

What is the command used to recompile the stored procedure at run time?

1015

---

How do I create an extended event in sql server?

900

---

Do you know what are pages and extents? : SQL Server Architecture

937

---

when you create a database how is it stored? : Sql server database administration

939

---

How to return the date part only from a sql server datetime datatype?

1021

---