SQL Server Query Performance Tuning Distilled, by Sajal Dam
This book doesn't teach you what to put in each table and how to put them together. But, when you have large tables it's very important to have good indexes, and to know how to evaluate that your queries are using them correctly. There is a good explanation of using the Profiler here, as well as a nice tutorial-style approach which explains how to improve your indexes based on the execution plans that the Query Compiler spits out.
When you divide the problem that way, you get the two cases which equal likelyhood:
in case mentioned boy is older:
B, B p = 1/3
B, G p = 2/3
in case mentioned boy is younger:
B, B p = 1/3
G, B p = 2/3
Why is it in both cases 1/3 vs. 2/3, and not, as you claim, 1/2. You have to look at the probability distribution of the underlying set. It is:
B, B = 1/4
B, G = 1/4
G, B = 1/4
G, G = 1/4
So all have the same likelyhood. In our breakdown into the two paths "younger and older" above notice how "B, B" is mentioned in both of them. Since "B, B" will occur on average just as often as "B, G" or "G, B", all the "B, B" cases will be split between the "boy younger" and "boy older" path, and it's probability of occurring in either path is thus halved when compared to it's alternative
When all Probabilitys are added up, the end result for the probability that you get B, B is the same.
p = 1/2 * p[path 1] + 1/2 * p[path 2]
p = 1/2 * 1/3 + 1/2 * 1/3 = 1/3
No, he didn't "see" a random memory error. Maybe you can see them, i sure as hell can not.
He noticed a program had stopped working for unexplained reasons, and did some pretty nifty debugging to get to the bottom of it.
Yes, i'd have rebooted too. But not because i think that what he did was a waste of time, just wouldn't have known how to do it.
And as for memtest, yes you can use it to find out if you have really shitty ram. But it's no magic wand, what if the ram is working mostly fine, and an error appears on average only once a year? You'd have to run memtest for years to test for that with certainity, and what's the point of having a computer then if you can't use it?
What i found funny btw is the hostname "psychotique", no wonder it is giving problems.
I was actually kind of puzzled why google took out that feature. Was allways so funny to read "swim across the atlantic ocean..". Maybe their lawyers thought about it and decided to not take any chances:(
11:50
"Open source software. These guys decided they didn't want copyright protection. They thought it'd be more innovative without it."
Replace "copyright protection" by "to use their exclusive rights granted by a copyright to prevent others from selling copies of their product". I don't know if this definition is technically correct, but from the context of her speech i think it was what she actually meant. Maybe it was prone for misunderstanding, that some people might think that OSS is PD, but i think your categorical "False" is too harsh a judgement.
Medicine is heavily regulated, no free market there
Of course, if you remove those regulations you get tons of quacks ripping people of. So they are propably there for a good reason. But when it takes millions and millions just to get the paperwork done to start some trials, it seems the bureaucracy is overblown currently
The previous gen. NV Cards don't do DX11, thus where running this bench in DX10 mode.
Which is kind of a misleading thing for THG to do, while they explained it in the text they should have made seperate chart for those two modes to make it clear on thirst glance.
There is a comparison of image quality in Unigine Benchark (DX10 vs. DX11) out there somewhere, and the difference is night and day.
In civ4, catapults do only damage part of the units in a stack.
So if i send a stack of of 30 Units on attack, and AI smashes a Catapult against that, only a few units will get damaged. A sizeable amount of catapults you have to worry, put when there just a few you can in practise just ignore them mostly.
The only thing cats are really strong at is in city-attack, because they can bombard defences and you can promote them to get a bonus at it.
They could of course change the game-balance so that catapults would damage a stack more, but then there would be crys that catapults are overpowered and need to be nerfed. Better to do away with the "50 units on same square" silliness.
Keeping the P4 may Cost lest, and Cost can also be an indicator of total power consumed. It's not only about the power running through the socket where the Computer is plugged in, but also about manufacturing costs of the components.
I'm still typing this on a P4. It's plenty fast enough for office work. The CPU is idle most of the time, and in that state even a P4 doesn't use that much power.
It may not be groundbreaking, but it's a good game.
"Decent amount" it may be true that there are not many yet, but there are allready some good free versions of the quake-type game e.g., so we may see some good free games in the future.
Ok i read that whole bug thread, and the only "security risk" i could see was the following:
On a public computer someone could change the screensaver settings to display offensive text. "the CEO is a bastard" O noes!! Can't have that.
It seems config functionality wasn't added to gnome-screensaver for years, no idea if it's in by now. My opinion of gnome project just went down a notch.
I hate it as well. The main reason is that it is slow. When i type in that bar i wan't the choices displayed immediately, not with delay while that stupid bar does a internet search based on what i am typing.
Fortunately there is still a way out with ff:
Install the oldbar Extension (does away with the !awesome bar and gives back the ff 2 bar)
Change these prefs from their defaults to:
accessibility.typeaheadfind.flashBar 0
browser.urlbar.matchOnlyTyped true
But thanks for the tip with seamonkey, will have a look that too.
Either nobody skilled enough cared to use a disasembler to figure out how the update mechanism works, or the worm author has built in some crypto scheme where the updates must be signed.
This only makes sense if it is verified immediately by the majority of the voters.
If it's just an internal hard copy, a manipulated machine can just "punch out" the same wrong vote that is stored, while fooling the voter on the display.
Now what's the point of complicated and expensive machines which would present a printout to voters, ask for confirmation, etc?
Pen&Paper voting is much cheaper, and very secure.
The authors answer that it is via the scientific method. This is determined only after strict and careful analysis of a clinical study, of which the most effective is double-blind and randomized.
I don't know if homeopathy works. But let's suppose for a moment it does, and that there are skillful practitioners of the craft. Why would they not wan't to prove it by doing such studies?
I can think of a reason: Morality. When you allready know, by expierience, that something helps with given symptoms, the study would require that you do not give that to sick people, but instead give them something completely different without telling them.
Also i find the statement that it's "impossible to work" quite arrogant. How to you know for sure? Have they found the Higgs Boson yet? We do not know (and may never find completly find out) how everything works exactly. Just because there are no molecules left doesn't mean that there could not be some other mechanism by which information about the substance being there is retained.
This will often be the case, but i think they can be other reasons. Just look at the Side effects sections on the wiki page for SSRI. This stuff is exactly the right stuff for many people, and helps them tremendosly. But how exactly the brain works isn't fully understood, and it will be prescribed to people where messing with the seratonin levels does more harm than good. Would you like to be told eat some substance that will mess with your mind?
Most likely the app will use the Standard C Library in some way (eg. memcpy, malloc..) On windows/cygwin these functions are implemented in cygwin1.dll, which your program will be linked with. In linux it will be linked against glibc, so the platform does matter.
A fridge is normaly well insulated, and thers no heat producing source inside. Athlon CPUs produce quite a lot of heat (50 Watt under load). Add to this the other Components and the fridge has to transfer alot of thermal energy outside.. I guess the motor would run all the time...
That's why you should put the name of the release (ie. potato, woody) in/etc/apt/sources.list, and not the symlink (stable, frozen, unstable).
Re:And What's Single-Player REALLY Going To Be Lik
on
New Doom Details
·
· Score: 1
> "Great single-player experience" to me now
> is defined by having a great story being
> told during my travails through the plot.
I also like great storylines in games.
Sometimes it feels like watching a movie where u have to move the main character(s) through it, walk to location x, activate trigger y... Great, game gives me another chunk of story.. (repeat)
In these games (e.g. FF7), i really wan't to see how the story developes, how the game ends, etc.. somehow the story _forces_ me to play the game... yet sometimes i don't like the gameplay itself that much (at least not _that_ much to play it for weeks..).
Halflife is a great game, but as for the story it's really not so much more original as the quake1 story. In both there's a dimensional gateway open'ed, and lot's of evils and a big boss
cause trouble. Halife does a much better of integrating the story in the gameplay and detailing it, tho.
I still like singleplayer Doom. It's great fun, and u can try crazy stuff like not using any weapon to finish a level. It's similar to those old action games which all had maybee 1/2 page of a story but are great fun playing.
Same with quake1, try completing levels as fast as possible! Great Fun!
>They've always relied on flash
>and graphics for user immersion.
Yeah, interesting level layout/design, cool monsters,items,etc. , fast gameplay, great game physics...
If you wan't a good story just think together your own while you play:)
This book doesn't teach you what to put in each table and how to put them together. But, when you have large tables it's very important to have good indexes, and to know how to evaluate that your queries are using them correctly. There is a good explanation of using the Profiler here, as well as a nice tutorial-style approach which explains how to improve your indexes based on the execution plans that the Query Compiler spits out.
in case mentioned boy is older:
B, B p = 1/3
B, G p = 2/3
in case mentioned boy is younger:
B, B p = 1/3
G, B p = 2/3
Why is it in both cases 1/3 vs. 2/3, and not, as you claim, 1/2. You have to look at the probability distribution of the underlying set. It is:
B, B = 1/4
B, G = 1/4
G, B = 1/4
G, G = 1/4
So all have the same likelyhood. In our breakdown into the two paths "younger and older" above notice how "B, B" is mentioned in both of them. Since "B, B" will occur on average just as often as "B, G" or "G, B", all the "B, B" cases will be split between the "boy younger" and "boy older" path, and it's probability of occurring in either path is thus halved when compared to it's alternative
When all Probabilitys are added up, the end result for the probability that you get B, B is the same.
p = 1/2 * p[path 1] + 1/2 * p[path 2]
p = 1/2 * 1/3 + 1/2 * 1/3 = 1/3
He noticed a program had stopped working for unexplained reasons, and did some pretty nifty debugging to get to the bottom of it. Yes, i'd have rebooted too. But not because i think that what he did was a waste of time, just wouldn't have known how to do it.
And as for memtest, yes you can use it to find out if you have really shitty ram. But it's no magic wand, what if the ram is working mostly fine, and an error appears on average only once a year? You'd have to run memtest for years to test for that with certainity, and what's the point of having a computer then if you can't use it?
What i found funny btw is the hostname "psychotique", no wonder it is giving problems.
I was actually kind of puzzled why google took out that feature. Was allways so funny to read "swim across the atlantic ocean..". Maybe their lawyers thought about it and decided to not take any chances :(
11:50 "Open source software. These guys decided they didn't want copyright protection. They thought it'd be more innovative without it."
Replace "copyright protection" by "to use their exclusive rights granted by a copyright to prevent others from selling copies of their product". I don't know if this definition is technically correct, but from the context of her speech i think it was what she actually meant. Maybe it was prone for misunderstanding, that some people might think that OSS is PD, but i think your categorical "False" is too harsh a judgement.
Medicine is heavily regulated, no free market there
Of course, if you remove those regulations you get tons of quacks ripping people of. So they are propably there for a good reason. But when it takes millions and millions just to get the paperwork done to start some trials, it seems the bureaucracy is overblown currently
If you ever look at :version, it spits out this huge list of features, each with a "+/-" in front.
I suppose when you build your own custom verion, there is a way that you can configure your version to leave most of those features out.
In fact debian seems to have done just that, they ship "vim.tiny" in the base install with just 640k, which should be enough for everyone.
repeat 5 times
The previous gen. NV Cards don't do DX11, thus where running this bench in DX10 mode. Which is kind of a misleading thing for THG to do, while they explained it in the text they should have made seperate chart for those two modes to make it clear on thirst glance. There is a comparison of image quality in Unigine Benchark (DX10 vs. DX11) out there somewhere, and the difference is night and day.
So if i send a stack of of 30 Units on attack, and AI smashes a Catapult against that, only a few units will get damaged. A sizeable amount of catapults you have to worry, put when there just a few you can in practise just ignore them mostly.
The only thing cats are really strong at is in city-attack, because they can bombard defences and you can promote them to get a bonus at it.
They could of course change the game-balance so that catapults would damage a stack more, but then there would be crys that catapults are overpowered and need to be nerfed. Better to do away with the "50 units on same square" silliness.
Keeping the P4 may Cost lest, and Cost can also be an indicator of total power consumed. It's not only about the power running through the socket where the Computer is plugged in, but also about manufacturing costs of the components. I'm still typing this on a P4. It's plenty fast enough for office work. The CPU is idle most of the time, and in that state even a P4 doesn't use that much power.
1mg = 1/1000 g = 1E-6kg Thus your Result is too high. Should be 0.26 kg i guess. Which would still be a lot of plastic to eat..
http://www.zincland.com/powder/
It may not be groundbreaking, but it's a good game.
"Decent amount" it may be true that there are not many yet, but there are allready some good free versions of the quake-type game e.g., so we may see some good free games in the future.
Ok i read that whole bug thread, and the only "security risk" i could see was the following:
On a public computer someone could change the screensaver settings to display offensive text. "the CEO is a bastard" O noes!! Can't have that.
It seems config functionality wasn't added to gnome-screensaver for years, no idea if it's in by now. My opinion of gnome project just went down a notch.
I hate it as well. The main reason is that it is slow. When i type in that bar i wan't the choices displayed immediately, not with delay while that stupid bar does a internet search based on what i am typing.
Fortunately there is still a way out with ff:
Install the oldbar Extension (does away with the !awesome bar and gives back the ff 2 bar)
Change these prefs from their defaults to:
accessibility.typeaheadfind.flashBar 0
browser.urlbar.matchOnlyTyped true
But thanks for the tip with seamonkey, will have a look that too.
Either nobody skilled enough cared to use a disasembler to figure out how the update mechanism works, or the worm author has built in some crypto scheme where the updates must be signed.
Now what's the point of complicated and expensive machines which would present a printout to voters, ask for confirmation, etc?
Pen&Paper voting is much cheaper, and very secure.
The authors answer that it is via the scientific method. This is determined only after strict and careful analysis of a clinical study, of which the most effective is double-blind and randomized.
I don't know if homeopathy works. But let's suppose for a moment it does, and that there are skillful practitioners of the craft. Why would they not wan't to prove it by doing such studies? I can think of a reason: Morality. When you allready know, by expierience, that something helps with given symptoms, the study would require that you do not give that to sick people, but instead give them something completely different without telling them.
Also i find the statement that it's "impossible to work" quite arrogant. How to you know for sure? Have they found the Higgs Boson yet? We do not know (and may never find completly find out) how everything works exactly. Just because there are no molecules left doesn't mean that there could not be some other mechanism by which information about the substance being there is retained.
This will often be the case, but i think they can be other reasons.
Just look at the Side effects sections on the wiki page for SSRI. This stuff is exactly the right stuff for many people, and helps them tremendosly. But how exactly the brain works isn't fully understood, and it will be prescribed to people where messing with the seratonin levels does more harm than good. Would you like to be told eat some substance that will mess with your mind?
Found this link on the SSRI wiki page:
relationship between antidepressant drugs and suicidality in adults
http://www.fda.gov/ohrms/dockets/ac/06/briefing/2006-4272b1-01-FDA.pdf
page 112 shows the suicidality by age group, when compared to placebo
Most likely the app will use the Standard C Library in some way (eg. memcpy, malloc..)
On windows/cygwin these functions are implemented in cygwin1.dll, which your program will be linked with. In linux it will be linked against glibc, so the platform does matter.
A fridge is normaly well insulated, and thers no heat producing source inside. Athlon CPUs produce quite a lot of heat (50 Watt under load). Add to this the other Components and the fridge has to transfer alot of thermal energy outside.. I guess the motor would run all the time...
That's why you should put the name of the release (ie. potato, woody) in /etc/apt/sources.list, and not the symlink (stable, frozen, unstable).
> is defined by having a great story being
> told during my travails through the plot.
I also like great storylines in games. Sometimes it feels like watching a movie where u have to move the main character(s) through it, walk to location x, activate trigger y... Great, game gives me another chunk of story.. (repeat)
In these games (e.g. FF7), i really wan't to see how the story developes, how the game ends, etc.. somehow the story _forces_ me to play the game... yet sometimes i don't like the gameplay itself that much (at least not _that_ much to play it for weeks..).
Halflife is a great game, but as for the story it's really not so much more original as the quake1 story. In both there's a dimensional gateway open'ed, and lot's of evils and a big boss cause trouble. Halife does a much better of integrating the story in the gameplay and detailing it, tho.
I still like singleplayer Doom. It's great fun, and u can try crazy stuff like not using any weapon to finish a level. It's similar to those old action games which all had maybee 1/2 page of a story but are great fun playing.
Same with quake1, try completing levels as fast as possible! Great Fun!
>They've always relied on flash
>and graphics for user immersion.
Yeah, interesting level layout/design, cool monsters,items,etc. , fast gameplay, great game physics...
If you wan't a good story just think together your own while you play :)
I agree. Just imagine what irc would be like if you couldn't /ban idiots from a channel.
http://www.debian.org/support#irc
http://www.infodrom.north.de/Debian/user.html