Answer Posted / anjan ghosh

when we create index then we assign a primary or unique
field , after insert of records , the results is
clustered--(field) order by
nonclustered--no order(logical order)

create table nonclusterindex(Emid int,data varchar(800))
create table clusterindex(Emid int,data varchar(800))

create unique nonclustered index nonclusterindex_emid on
nonclusterindex (Emid)

create unique clustered index clusterindex_emid on
clusterindex (Emid)

What are the different type of replication in sql server?

933

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

901

---

What is advantage data architect?

865

---

Explain what is analysis service repository?

926

---

Is sql server 2016 free?

885

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1131

---

What is user defined datatypes and when you should go for them?

963

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

991

---

What is a recursive stored procedure in sql server?

1086

---

What is the difference between ddl,dml and dcl commands?

1057

---

how to do partition in sqlserver

2408

---

How to provide default values to function parameters?

1051

---

How to list all tables in the database using odbc_tables()?

982

---

When a primary key constraint is included in a table, what other constraints does this imply?

939

---

What are the types of sql server?

988

---