Viewing 15 posts - 1 through 15 (of 29 total)
Since for Read Committed Snapshot, consistency is guaranteed only for the Statement, I believe you can still have repeatable read (and the other) problems.
Of course, and anyone need no more...
March 29, 2014 at 7:53 am
OK, but one minute later(after crush of E:) MyDB WILL BE off-line, right?
January 21, 2014 at 9:14 am
GilaMonster (3/3/2013)
They're the same thing. They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.
Understand. Suppose thing like this,...
March 4, 2013 at 7:23 am
It was just outstanding explanation! Now the whole picture is much clearer for me, I see where my mistake was.
A thousand thanks for your help!
October 8, 2012 at 10:10 am
GilaMonster (6/6/2012)
Execution contexts aren't reused, they're specific to a single query's execution.
Hmmm... Guess it's not true. From here:
Suppose that a batch B contains an "if" statement. When B begins execution,...
August 20, 2012 at 10:59 am
ChrisM@Work (7/9/2012)
Shcherbunov Neil (7/7/2012)
ChrisM@home (7/6/2012)
Not quite - NOEXPAND is the hint to use the view.
Yes, but ONLY if you reference view (not table!) in your query. See code example in...
July 9, 2012 at 4:44 am
ChrisM@home (7/6/2012)
Not quite - NOEXPAND is the hint to use the view.
Yes, but ONLY if you reference view (not table!) in your query. See code example in start message -...
July 7, 2012 at 6:26 am
1. SQL Server won't sub in an indexed view if the query is trivial - and it is.
My guess - this statement bears the stamp of truth. If query optimizer...
July 6, 2012 at 11:05 am
Gullimeel (7/6/2012)
Did you use the set options properly while creating the table,as well as indexed view and whiel querying the data?
Thanks and Yes - I have inserted the code
SET ANSI_NULLS...
July 6, 2012 at 10:54 am
GilaMonster (4/1/2012)
The minimum LSN column (which only appears for a end checkpoint) is the minimum LSN of that checkpoint operation
Yes, you are absolutely right, as it turns out, Minimum LSN...
April 2, 2012 at 12:28 am
A!!! Think you are right, Kalen says about different minLSN, thanks to you for clear!
But Kalen should choose less confuse term for "her" minLSN, 'Minimum crash LSN', may be. "Minimum...
March 30, 2012 at 7:04 am
No ideas??
March 22, 2012 at 12:41 am
johnitech.itech (2/5/2012)
Operators and functions are either collation sensitive or insensitive.
Collation sensitive
This means that specifying a No-collation operand is a compile-time error. The expression result cannot be No-collation.
Collation insensitive
This means...
February 5, 2012 at 8:03 am
johnitech.itech (2/2/2012)
try below soluhttp://forums.aspfree.com/microsoft-sql-server-14/collation-conflict-20773.html
Your link just not relevant to my question, sorry.
February 2, 2012 at 9:22 am
Ahhh! Thanks to all of you guys! And many thanks to SQL Kiwi personally. With his last 2 replays I, at last(!), capture the essence of things. Look, it's interesting!!...
January 30, 2012 at 2:29 am
Viewing 15 posts - 1 through 15 (of 29 total)