Answer Posted / arvind rohit

SELECT IDENT_CURRENT('table_name') ;

What are page splits?

577

---

What is cdc in sql server?

566

---

How many clustered indexes there can be on table ?

596

---

What are different types of constraints?

507

---

What's new in sql management studio for sql server? : sql server management studio

574

---

---

Do you know the isolation level that sql server support?

522

---

Can you index views?

498

---

What are points to remember while using the fillfactor argument?

526

---

How to find which stored procedure is currently running in sql server?

488

---

What are different types of statements that are supported by sql?

590

---

Can we deploy SSRS reports on our personal website?

123

---

Can you name a few encryption mechanisms in sql server?

536

---

Does order by actually change the order of the data in the tables or does it just change the output?

653

---

Do you know what is lock escalation?

576

---

What is the difference between value type and reference type?

549

---