How SQL uses Memory

Question

How SQL uses Memory

Viewing 14 posts - 16 through 28 (of 28 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Ninja's_RGR'us (1/3/2012)
Wow, you guys are so underpaid for this!

No one writes books for money. Just ask Grant.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Wow, you guys are so underpaid for this!
No one writes books for money. Just ask Grant.

So what's the real drive then?

Jared SSC Guru Points: 61793 More actions · Answer 3

Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Yes, read the book!
She's not lazy, it's not something she can answer in 2 words.
Just to put things in perspective, the chapter that I'm referring you to is 28 pages long and took me several days to properly tech-edit.
Wow, you guys are so underpaid for this!

lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."

Jared
CE - Microsoft

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Wow, you guys are so underpaid for this!
No one writes books for money. Just ask Grant.
So what's the real drive then?

Challenge. Brand. Love of teaching.

Dunno, I've never written one.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

SQLKnowItAll (1/3/2012)
lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."

And none of us got a cent for either of those books.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 6

GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
GilaMonster (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Wow, you guys are so underpaid for this!
No one writes books for money. Just ask Grant.
So what's the real drive then?
Challenge. Brand. Love of teaching.
Dunno, I've never written one.

You have written many articles. May I know why didn’t you inclined to write a book? It would be really nice if you do.

GilaMonster (1/3/2012)
SQLKnowItAll (1/3/2012)
lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."
And none of us got a cent for either of those books.

I am very sure many Publishing Houses would offer you good sum if you make your mind to be a Technical Author.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

My guess is that a decent book is at least 1-2 000 hours. I don't think publishing houses will give 100K to write the book ;-).

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Dev (1/5/2012)
GilaMonster (1/3/2012)
SQLKnowItAll (1/3/2012)
lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."
And none of us got a cent for either of those books.
I am very sure many Publishing Houses would offer you good sum if you make your mind to be a Technical Author.

Before you say something you may regret, go and look at the two Deep Dives books and see why none of the authors received any payment for them.

And no, writing does not pay 'good sums', any author will tell you that.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Ninja's_RGR'us (1/5/2012)
My guess is that a decent book is at least 1-2 000 hours. I don't think publishing houses will give 100K to write the book ;-).

Just editing Jonathan's book easily took me 30 days (8-10 hours a day), as a conservative estimate. Some chapters took as little as 2 days, some more than 5. That was just editing.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 10

GilaMonster (1/5/2012)
Dev (1/5/2012)
GilaMonster (1/3/2012)
SQLKnowItAll (1/3/2012)
lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."
And none of us got a cent for either of those books.
I am very sure many Publishing Houses would offer you good sum if you make your mind to be a Technical Author.
Before you say something you may regret, go and look at the two Deep Dives books and see why none of the authors received any payment for them.
And no, writing does not pay 'good sums', any author will tell you that.

I might disagree to you on this. I guess it differs from country to country (not sure for US / SA). I know some novelist / newspaper columnist they earn more than a mid-level Manager (in decent city) might get.

Anyways you said authors don’t write for money. Then it shouldn’t be any criteria any more 😛

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

GilaMonster (1/5/2012)
Ninja's_RGR'us (1/5/2012)
My guess is that a decent book is at least 1-2 000 hours. I don't think publishing houses will give 100K to write the book ;-).
Just editing Jonathan's book easily took me 30 days (8-10 hours a day), as a conservative estimate. Some chapters took as little as 2 days, some more than 5. That was just editing.

So writing it the first time (which includes 5-10 rewrittes or rewording and building exemples, scripts, etc), all that must be a good 200-300 days full time. Assuming no writters block and no major edit requests from the publisher.

Sounds like a fun career :hehe:.

Jared SSC Guru Points: 61793 More actions · Answer 12

Dev (1/5/2012)
GilaMonster (1/5/2012)
Dev (1/5/2012)
GilaMonster (1/3/2012)
SQLKnowItAll (1/3/2012)
lol However, it is good to know that books that are paid fr can help people around the world; i.e. SQL Server MVP Deep Dives. I got both volumes for X-Mas and am "diving in."
And none of us got a cent for either of those books.
I am very sure many Publishing Houses would offer you good sum if you make your mind to be a Technical Author.
Before you say something you may regret, go and look at the two Deep Dives books and see why none of the authors received any payment for them.
And no, writing does not pay 'good sums', any author will tell you that.
I might disagree to you on this. I guess it differs from country to country (not sure for US / SA). I know some novelist / newspaper columnist they earn more than a mid-level Manager (in decent city) might get.
Anyways you said authors don’t write for money. Then it shouldn’t be any criteria any more 😛

Dev, I think one of the main differences between a career author and a technical author is just that... One makes their living off of it and requires the income to live. Most technical writers of books do not. A writer of a fiction book makes their money because of the number of copies that the publisher will sell by choosing that author. A novelist also has a significantly larger population of people interested in their books. A non-fiction author will NEVER make what a novelist makes from a publishing company because the number of people that may be even interested in the book, let alone will buy it, is thousands if not millions of times smaller. The collective "we" here (outside of those who write fiction) have an extremely limited audience and also make our living from database development or administration. "We" write to help others that are interested in what interests us. A publisher will not pay a significant amount of money to one of us to write a book because someone else will do it for free and the cost of publication is not worth the ROI with the limited audience. I can guarantee this because I have researched the market for publishing and it is not a place to make a living as a writer of technical books. (I am certainly NOT referring to technical writers of documentation as there is a good market there.)

Jared
CE - Microsoft

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 13

Hope this helps you..this is nice article about memory usage in sql

http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html

Duran SSChampion Points: 13259 More actions · Answer 14

Duran

SSChampion

Points: 13259

January 5, 2012 at 10:24 am

#1429183

Thanks, that's a really good post.

Regards,

Paul.