Viewing 15 posts - 4,486 through 4,500 (of 49,571 total)
Piotr ER (10/16/2015)
Ok, i should write "when transaction fails and rollback is completed" :). But when rollback is done - you no longer need log records.
That's still not true in...
October 16, 2015 at 4:56 am
Piotr ER (10/16/2015)
October 16, 2015 at 4:19 am
Justin Manning SA (10/16/2015)
Fair enough.. but surely a 60GB file is too small?
Assuming that the OP is talking about the page file, probably not, unless the server's crashing often...
October 16, 2015 at 3:35 am
mahi123 (10/16/2015)
what is the use LDF file in Simple recovery model data base.
Transaction rollbacks, database recovery after a shutdown, database integrity, minor things like that.
Is there any possibility to remove...
October 16, 2015 at 3:28 am
BL0B_EATER (10/16/2015)
GilaMonster (10/16/2015)
Eirikur Eiriksson (10/16/2015)
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...Did you just upgrade to Windows 10?
Err, no.
win10...
October 16, 2015 at 3:14 am
Justin Manning SA (10/16/2015)
GilaMonster (10/16/2015)
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
It was, about 10...
October 16, 2015 at 3:10 am
Alan.B (10/15/2015)
-- Create a table
IF OBJECT_ID('tempdb..#X') IS NOT NULL DROP TABLE #X;
CREATE TABLE #X (x int)
-- start transaction
BEGIN TRANSACTION
INSERT #X SELECT 1
INSERT #X SELECT 2
...
October 16, 2015 at 3:07 am
Agnii (10/15/2015)
October 16, 2015 at 2:47 am
Justin Manning SA (10/16/2015)
Isn't the rule of thumb for a Virtual Memory/Page file to be set to 1.5 x amount RAM?
It was, about 10 years ago....
October 16, 2015 at 2:44 am
Eirikur Eiriksson (10/16/2015)
GilaMonster (10/15/2015)
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...Did you just upgrade to Windows 10?
Err, no.
October 16, 2015 at 2:42 am
Check the permissions of the public role.
October 15, 2015 at 1:27 pm
Oh, and the bloody desktop booted clean to windows on the first try tonight and is behaving itself...
October 15, 2015 at 1:04 pm
Eirikur Eiriksson (10/15/2015)
Gail, let us know where and when 😉
According to my blog dashboard, part 1 is scheduled for 3rd November.
October 15, 2015 at 12:55 pm
Virtual memory set to 60GB where? What, exactly do you mean (because virtual memory is fixed on a windows machine based on whether it's 32 or 64 bit, it's not...
October 15, 2015 at 12:10 pm
What exactly do you mean 'virtual memory is set to 60GB'?
And what exactly are you looking at when you say a 'virtual memory spike'?
And 3 Terabytes of RAM????
October 15, 2015 at 9:15 am
Viewing 15 posts - 4,486 through 4,500 (of 49,571 total)