I had a strange experience just now.
I noticed that when I started my SQL Server 2012 service, the SQL Serve process would start allocating more and more memory and it would quickly reach the memory limit.
I also noticed that the disk system was quite active, even though there was nothing obvious to make it so.
Continue reading […] SQL Server 2012 consumes all memory on startup […]
A new article of mine is out!
This time I write about the meaning of “my database is slow” and what hidden secrets database contain. I.e. databases are never a single player in the game of performance.
Here is the article: How come the Hourglass? Why database applications slow down.
Reading books is a very labor-intensive task (well, at least when taken seriously!).
It is not easy for several reasons:
We have to figure out the level of the book according to our knowledge level
We have to question the book’s title
We have to question the structure and the content
And why we have to question, you would ask.
Continue reading […] SQL Server Interview Questions and answers – earning the honor of thinking […]