Doesn't affect the log shipping at all. The only time a full backup needs to be copied is when the log shipping's broken and needs to be reset, even then...

JohnPapa (2/6/2013)

---

In the recordset the RV value is not Null, nothing prints when you try to print the value and the field is empty on the form. I will look...

No.

Please read through this - Managing Transaction Logs[/url]

Again, don't display it. There's absolutely no value in what it looks like and if all you need to do is compare it, it does not need to be displayed.

Have...

There's a good chance that's a contributing factor (the rowlock usage)

Why snapshot isolation allowed and still using nolock hints? All the downsides of...

Ok, so read it from the recordset into a variable (or leave it in the recordset) and compare when you're going to do the update.

Have you got any of the lock escalation traceflags turned on? Are you using any locking hints?

5 year old thread. Please post new questions in a new thread. Thanks

Indexing:

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

http://www.sqlservercentral.com/articles/Indexing/68636/

When you create an index, the column or set of columns that the index is created on is the key columns.

In the stored procedure that does your updates. In the VB code. Up to you.

There's no point at all in displaying it though, no user's going to understand the meaning...

nick.mcdermaid (2/6/2013)

---

Can anyone recall if they have run into an issue like that before? SQL incorrectly estimates a very large result set (almost a cross join) when in fact the...

It's...

I'm not a VB programmer. Why would you want to display it anyway? It's a binary value, meaningless to any user.

btw...

&...

nick.mcdermaid (2/6/2013)

---

OK I extracted what I think is the actual plan from sys.dm_exec_query_plan and it was identical to the estimated one that I uploaded, so we can assume the uploaded...

Huh? Don't understand the question.