Answer Posted / adhi

USE AdventureWorks;
GO
DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 300);
GO

How can I tell if sql server is 32 or 64 bit?

707

---

What is self join in sql server joins?

737

---

What are transactions and its controls?

796

---

Explain how does the report manager work in ssrs?

705

---

What are basics of policy management?

826

---

---

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

783

---

What is thr feature of change data capture?

674

---

Do you think BCNF is better than 2NF & 3NF? Why?

999

---

Why use “nolock” in sql server?

722

---

How to create a view using data from another view?

728

---

What are different types of database indexes?

690

---

What is update locks?

660

---

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

689

---

List the ways in which dynamic sql can be executed?

792

---

How is sql used in sql server?

672

---