Viewing 15 posts - 286 through 300 (of 8,416 total)
Updated my SQLCLR function to produce the results needed in this thread:
[font="Courier New"]
public static TimeSpan GetIntervalAsTime(DateTime Start, DateTime End)
{
return
(Start <= End) ?
End.Subtract(Start) :
End.AddDays(1).Subtract(Start);
}
[/font]
Test data:
With MyCTE (ID, aTime, bTime)
AS
(
SELECT 1, CONVERT(datetime2,'1900-01-01...
September 7, 2012 at 6:31 pm
ScottPletcher (9/7/2012)
TimeResult1 = -- ChrisR (5 date functions, 2 datatype conversions)
TimeResult2 = -- ChrisM (5 date functions, 2 datatype conversions)
...
September 7, 2012 at 6:19 pm
Sergiy (9/7/2012)
Because if I'd see anything what would show CLEARLY "that there is NO ROW MODIFICATION where the object of the update is unchanged" I'd happily accept it.
In SQL Server...
September 7, 2012 at 6:31 am
Sergiy (9/7/2012)
Because if I'd see anything what would show CLEARLY "that there is NO ROW MODIFICATION where the object of the update is unchanged" I'd happily accept it.
Try this:
USE tempdb;
GO
IF...
September 7, 2012 at 5:45 am
sqldba4u (9/7/2012)
Max and Min memory have been setup and few GBs are left for OS. Clearing up cache is not releasing server memory.
Why do you want to 'release server memory'?
September 7, 2012 at 4:13 am
Usman Butt (9/7/2012)
I would also run DBCC against such databases, and if the corruption is the problem then would look into the root cause. But that is only me 🙂
DBCC...
September 7, 2012 at 4:10 am
Sergiy (9/7/2012)
MissTippsInOz (9/7/2012)
You have had numerous genuine responses from people who are trying to help you to understand the behaviour of a 'non-updating update'. You have been given code...
September 7, 2012 at 1:45 am
Sergiy (9/7/2012)
SQL Kiwi (9/7/2012)
September 7, 2012 at 1:35 am
Sergiy,
If the only point you are trying to make is that non-updating updates do write to a clustered index or heap page (without changing it in any way) I will...
September 7, 2012 at 1:20 am
Sergiy (9/7/2012)
Even if everything remained like it was before - there was a...
September 7, 2012 at 1:17 am
Sergiy (9/7/2012)
SQL Kiwi (9/7/2012)
If you don't stop being snarky in your replies
You may notice I just quoted you. Word to word.
And that is exactly the problem. My question...
September 7, 2012 at 1:14 am
Sergiy (9/7/2012)
So, there are modifications? SQL Server givees you another prove that the row is actually written to. Can you agree now?
A modification counter used by statistics update...
September 7, 2012 at 12:16 am
Sergiy (9/6/2012)
SQL Kiwi (9/6/2012)
The logical update operation.
What exactly is logical update operation and what other kind of update operatios are there?
I am trying to help you distinguish between a logical...
September 7, 2012 at 12:12 am
Sergiy (9/6/2012)
Is it your case? "Potentially updating resources"? So, why don't we see U locks in our examples?
Update locks are taken when reading rows that might qualify for a change...
September 7, 2012 at 12:07 am
Sergiy (9/6/2012)
September 6, 2012 at 11:47 pm
Viewing 15 posts - 286 through 300 (of 8,416 total)