I want to shrink the database to initial size which i have set for mdf and ldf file. I have set initial size for the database after creating the database.It...

When does page lock and row lock is taken?

can you please have a look at my question here

HowardW (8/9/2013)

---

sys.dm_exec_requests is the DMV with this information. There's a blocking session ID column. If you want something pre-packaged and easy to use in the future, I'd recommend sp_whoisactive.

Read committed...

Does nested transactions only supported in Transaction Statements(Transact-SQL ) ? In coding i am using 'sqlconnection' object. But inner transaction gets comited even though outer transaction fails

We tried to implement it.But if inner transaction gets commit first.I want inner transaction to roll backup if outer transaction...

If VLF count is more (about more than 100) then shrinking is necessary?

How to know the size to be set for the log file? Whether any method is there by which i can set ideal size for my ldf file.

I want to know how exactly log backup is different from differential backup? Because the differential backup contains differences from last full backup where as log backup is also used...

adb2303 (8/2/2013)

---

Each differential will be all the changes since the last full backup, i.e. they're not incremental. They can get quite big if not managed properly - even bigger...

Erland Sommarskog (8/2/2013)

---

The most important thing is that you and your team understands the recovery procedures, so that in case of a disaster you can meet your RPO and RTO....

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/26/2013)

---

IT researcher (7/26/2013)

---

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string...

ChrisM@Work (7/23/2013)

---

-- why cast [Phone no] AS VARCHAR(MAX)?

-- why use CHARINDEX? You don't need the character position, you only need to know if

-- one string exists inside the other.

SELECT...