I don't have link right now. If i got i'll post you.

Sometimes back i've read this kalen's book.

sqlzealot-81 (6/6/2011)

---

muthukkumaran Kaliyamoorthy (6/6/2011)

---

@sqlzealot-81,

What gail told is

An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an...

Your welcome sagar.

Get an expert's blog here. Which i have followed[/u]

@sqlzealot-81,

What gail told is

An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an insert.

GilaMonster (6/6/2011)

---

muthukkumaran Kaliyamoorthy (6/6/2011)

---

Yep, True the update will delete the value first...

Hi check the script added in my signature.

Yep, True the update will delete the value first and insert it.

Buy a SQL server 2008 internals book

http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-2008-Internals-ebook/dp/B0043EWUBQ

Saga... (6/6/2011)

---

Hi,

I am a B.E fresher July 2010 passout. I was very confused to choose between SQL Server DBA or Oracle DBA as per career choice.

But now I...

mpdillon (6/5/2011)

---

Grasshopper,

I hit a snag. When executing your code, I receive:

The backup set holds a backup of a database other than the existing 'B' database.

I think this will be cured...

chinn (6/3/2011)

---

I have a sql server 2008 64bit and windows 2008r2 64 bit and i have 8gb memory

and i set the max to 6gb and i see sql server always...

Syed Jahanzaib Bin hassan (6/4/2011)

---

select * from sys.dm_os_performance_counters

where counter_name like 'page life%'

First check the requirement of RAM with the help of this query,this will tell you about RAM required or...

Have a look :...

Check it here

http://www.techrepublic.com/blog/howdoi/how-do-i-configure-transactional-replication-between-two-sql-server-2005-systems/123

@Joydeep...