Viewing 15 posts - 14,386 through 14,400 (of 49,552 total)
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...
February 6, 2013 at 9:35 am
JohnPapa (2/6/2013)
February 6, 2013 at 9:27 am
mike 57299 (2/6/2013)
A full backup doesn't set the log to re-usable?
No.
February 6, 2013 at 9:24 am
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...
February 6, 2013 at 8:13 am
SQL Pizza (2/6/2013)
The developers use NOLOCK AND ROWLOCK.
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...
February 6, 2013 at 7:09 am
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.
February 6, 2013 at 6:59 am
Have you got any of the lock escalation traceflags turned on? Are you using any locking hints?
February 6, 2013 at 6:51 am
5 year old thread. Please post new questions in a new thread. Thanks
February 6, 2013 at 6:50 am
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.
February 6, 2013 at 6:50 am
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...
February 6, 2013 at 6:41 am
nick.mcdermaid (2/6/2013)
February 6, 2013 at 3:08 am
nick.mcdermaid (2/6/2013)
p.s. The plan that comes from sys.dm_exec_query_plan is the estimated plan, because it has no actual row counts.
Are you saying that actual plans are not in that table?
It's...
February 6, 2013 at 2:43 am
I'm not a VB programmer. Why would you want to display it anyway? It's a binary value, meaningless to any user.
btw...
&...
February 6, 2013 at 2:29 am
nick.mcdermaid (2/6/2013)
February 6, 2013 at 2:27 am
Huh? Don't understand the question.
February 6, 2013 at 2:22 am
Viewing 15 posts - 14,386 through 14,400 (of 49,552 total)