Answer Posted / brahma

Yes,
Begin transaction t1
update <Table_Name> set <col1>=<col1>+50
Begin Transaction t2
delete from <Table_Name> set <col1>=<col1>+100
commit Transaction t2
end transaction t1

How will you make an attribute not process? : sql server analysis services, ssas

1011

---

What are page splits? : SQL Server Architecture

938

---

Explain what is the difference between a local and a global temporary table?

938

---

What is sparse columns of sql server 2008?

994

---

Differentiate between a primary key and a unique key.

1001

---

Does the unique constraint create an index?

991

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

932

---

What is the optimization being performed in oracle and SQL Server?

999

---

What is sql collation?

1139

---

How many types of triggers are there?

1004

---

Does partitioning ssd reduce performance?

849

---

How can we improve performance by using SQL Server profiler?

987

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1853

---

Explain in brief how sql server enhances scalability of the database system?

937

---

what are the different types of replication you can set up in sql server? : Sql server database administration

971

---