jellybean (10/6/2015)

---

I do recall seeing message "x rows effected" but it may have been syntax error on my part. I *may* have done something like:

update someTable

set='newValue'

where someField='oldValue'

As I say -...

Unless they're starting a transaction and then walking away with it uncommitted. That would lead to this issue, possibly. As Gail says, we don't know what objects are being locked...

I'd suggest taking a look at the Minion tools, in your case Minion Backup[/url].

I might help some, but probably not much, especially considering the amount of memory you have on the system.

Locking and blocking are primarily an issue related to code and data...

You should be able to take another log backup and, assuming it succeeds, everything should be fine. You can check it by using RESTORE HEADERONLY to look at the Log...

Eirikur Eiriksson (10/5/2015)

---

Grant Fritchey (10/5/2015)

---

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you...

You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to...

I'd take a look at Louis Davidson and Tim Ford's book

Performance Tuning with SQL Server Dynamic Management Views

It's free to download.

As long as you're using the BACKUP DATABASE command to create the backup, you're getting a page by page copy of the database. The backup is going to be the...

If you have questions or hit snags along the way, you know where to go.

Best of luck.

Just remember that the Actual Plan requires that your run...

ChrisM@Work (10/2/2015)

---

Grant Fritchey (10/2/2015)

---

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/2/2015)

---

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/1/2015)

---

...

Also note that you will need to look at the Actual execution plan to see the plan change. The...

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/2/2015)

---

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/1/2015)

---

...

Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will...

Jason A. Long (10/2/2015)

---

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/1/2015)

---

...

Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will continue...

DMV = Dynamic Management Views

It's a way of accessing information about the system. You're focusing on the wrong things here. As others have pointed out, just because an index exists...