Viewing 15 posts - 196 through 210 (of 338 total)
hi, sachin nandawar!!!
i'm sorry, the time that i stay without post!! I was having problems with my work!
with relation the book - SQL Server 2008 Internals, this link: http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243 you...
June 12, 2011 at 1:31 am
Shawn Melton (6/9/2011)
June 11, 2011 at 2:44 am
Shawn Melton (6/8/2011)
Sachin Nandanwar (6/7/2011)
The book is Microsoft Published MCTS Self-Paced Training Kit(Exam 70-432) Chapter 9, page no 213, 3rd line from the top.
That book is covered with errors and...
June 8, 2011 at 11:53 pm
rfr.ferrari (6/8/2011)
DML = Data Manipulation Language, is is how we do the data manipulation, for example: insert, update, delete ...! it's recorded in transation log!!!
Yes I understand that.
But just wanted...
June 8, 2011 at 11:50 pm
rfr.ferrari (6/8/2011)
the LSN = Log Sequence Number, then to each transaction is generated one LSN !!!
Correct me if I am wrong but I believe that LSN is generated for...
June 8, 2011 at 11:41 am
The book is Microsoft Published MCTS Self-Paced Training Kit(Exam 70-432) Chapter 9, page no 213, 3rd line from the top.
June 7, 2011 at 3:12 am
Also set the MIN memory value and the option Lock Pages in Memory ON.This will make sure that sqlserver wont flush the memory to the OS
in case of memory pressure...
April 6, 2011 at 3:00 am
GilaMonster (3/28/2011)
Sachin Nandanwar (3/28/2011)
Truncation is the process of marking the inactive VLF's as activemarking active VLFs as inactive.
Yes sorry.Will update it.
March 28, 2011 at 8:16 am
So to conclude(Hopefully;-)) the discussion we had till now we covered two importants points.
1)Truncation and the Shrinking of log files and the cookie analogy.
The difference is
Truncation is the process of...
March 28, 2011 at 8:12 am
Hey Gail,
Thanks for such a nice explaination.
If my understanding is correct when a rollbacks happens and also a checkpoint in middle of an inflight transaction there will be basically 2...
March 28, 2011 at 4:52 am
Checkpoint writes the changed pages to disk. It does not flush the data cache...
Again now what does that mean and what exactly happens? Damn this is getting more and more...
March 28, 2011 at 3:38 am
The rollback changes the data pages in memory to their original values. A later checkpoint will flush them to disk again.
This is where I am getting confused.Just consider the scenario...
March 28, 2011 at 3:07 am
Wayne,
Surely I will view the videos. Due to limited access I am unable to do it right now in my office 🙁
But just one last confusion if you can clear...
March 28, 2011 at 2:50 am
Wayne now your explanation is exactly SPOT ON.Now the whole process has become crystal clear to me just like the cookie analogy Brandie had posted earlier.
Thanks to you Wayne and...
March 27, 2011 at 12:54 pm
The only unbreakable rule is log before data.
It writes the log records to disk at the point the transaction is committed (or sometimes before)
Does it hold true for a checkpoint...
March 27, 2011 at 12:12 pm
Viewing 15 posts - 196 through 210 (of 338 total)