Answer Posted / l. meher

When a SQL query is getting executed it goes through the
following steps:

1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
corresponding statement.
2)Validate the SQL statement.
3)Validate the source.
4)Acquire locks.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.

If you have any doubt mail me at lmeher.tcs@gmail.com
Thanks..

What are the steps to process a single select statement?

887

---

What the different components in replication and what is their use?

913

---

What is trace flag in sql server?

975

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1012

---

Explain raiserror in sql server?

962

---

What are data resources?

853

---

What is analysis service repository?

968

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

139

---

What is attribute? : sql server analysis services, ssas

978

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2465

---

Is oracle faster than sql server?

889

---

Explain powershell included in sql server 2008?

999

---

what is the system function to get the current user's user id? : Sql server database administration

953

---

What is a non equi join?

913

---