Answer Posted / neeraj sharma

When we fire the trigger then the data goes to temporary
tables. when we execute insert, delete, update trigger the
the data goes to temporary tables. these temporary tables
are called as magic tables. There to types of magic tables:
1. Inserted
2. Updated

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

940

---

How can you find out how many rows returned in a cursor?

1029

---

What is indexed view? How to create it?

1007

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1108

---

What is the difference between primary key and unique constraints?

961

---

What is sub query and its properties?

974

---

Can multiple columns be used in sql group by clause in ms sql server?

1049

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

975

---

Differentiate between truncate vs delete in mssql?

1083

---

what's the information that can be stored inside a bit column? : Sql server database administration

1033

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1075

---

Why do we use functions?

913

---

What is query cost in sql server?

995

---

Which data type columns are the best candidates for full-text indexing?

967

---

What do you understand by user-defined function in the sql server?

951

---