When does setting the SORT_IN_TEMPDB option actually improve performance?

My question is related to index rebuilding, mainly the SORT_IN_TEMPDB option.

BOL states that:

Even if other users are using the database and accessing separate disk addresses, the overall pattern of reads and writes are more efficient when SORT_IN_TEMPDB is specified than when it is not.

On the other hand, one of the users states:

When rebuilding an index you would need twice the space of the index + 20% for the sorting. So in general to rebuild every index in your db you only need 120% of your biggest index in your DB. If you use SORT_IN_TEMPDB, you only win 20%, you still need an aditional 100% in your data file. Further more, using sort in tempdb increases your IO load drastically, since instead of Writing the index one time to the datafile, you now write it one time to the tempdb and then write it to the data file. So that is not always ideal.

Would you like to share your own experience about this option? Have you ever had to use this option while rebuilding indexes? What was the performance result?

What does this permalink setting mean?

I just took over the maintenance of a wordpress website. It was moved to a new hosting. I found out that several links on the page didn’t work.

In the permalink settings i found this entry:

https://example.com/{86be….f}postname{8…..39f}/

A lot of numbers and characters in curly brackets. Can anyone give me a hint where this comes from? A plugin? A hack?

Thx in advance!

Setting custom search engine indexing for a “dynamic wordpress page” with htaccess

I am searching for hours but didnt found the code for my requirement, Can my requirement be done with htaccess?

Requirement – These urls of a page should be indexed by Google:

  1. example.com/example-page
  2. example.com/example-page?para_a=1&para_b=1
  3. example.com/example-page?para_a=2&para_b=2

Requirement – But this page with all other parameters in url should NOT be indexed by Google.

I found these code parts:

<If "%{QUERY_STRING} =~ /foo=bar/"> ... </If> 

.

<If "req('Host') != 'www.wooga.com'"> ... </If> 

.

<Directory /var/www/html/> ... </Directory> 

.

Header set X-Robots-Tag "noindex" 

I have no idea which combination of code will work for me. Please tell me if anyone knows. Thanks.

I’m gonna do a campaign with a Victorian London x American 1940’s setting and i’m unsure what to do with equipment [on hold]

I wanted to treat my players to a special campaign with an out of the ordinary setting. The style would be a combination of Victorian London(using it’s cobblestone streets and style of architecture primarily) and 1940’s America(using basically everything other than the style of architecture).

I figured guns would replace bows and crossbows, but I wasn’t sure what to do about melee weapons, specifically swords and axes as well as heavy armor and medium armor. (If you’re wondering, yes, I’m including magic and all the fantasy races and such)

I wanted to essentially combine la Noire with Call of Cthulhu and the movie Bright except make it as good as possible and make everything feel right and like it belongs and isn’t being forced in place so my players get a smooth flow as they play

Setting precision and machine underflow

As is well known, Mathematica changed how it handles numbers smaller than $ MinMachineNumber in recent versions.

I’m running Mathematica 12 on a Mac, and I cannot figure out why it’s treating these differently:

   Exp[-N[2695, $  MachinePrecision]]    Exp[-N[2695.0, $  MachinePrecision]] 

The top line returns 3.77… times 10^-1171 while the bottom line gives the “too small to represent as a normalized machine number” error and returns zero.

Since both numbers are set to MachinePrecision I’d think that the fact that the bottom one has the added .0 is irrelevant, but obviously my understanding is wrong.

Running

    N[Precision[-N[2695, $  MachinePrecision]]]     N[Precision[-N[2695.0, $  MachinePrecision]]] 

confirms both exponents have the same precision.

I’d greatly appreciate it if someone could explain why Mathematica is treating these differently to me.

Setting a shortcut to change focus to a different section in a web app?

Let’s say you have a web app with 3 sections. A left nav menu, a toolbar/settings section, and a main application area. Most of the time, the user will be engaging directly with the application, and their document’s focus will be potentially somewhere deep inside of the application’s “hierarchy”, meaning that tabbing into/out of the application to place focus on the left nav or toolbar will be a pain.

Is adding a shortcut (and making the shortcut’s keystrokes visible next to that section maybe?) to change focus to the left navigation menu or the toolbar a good idea generally? Otherwise they may have to do a lot of tabbing or use some other method of interacting with that part of the site, which we’d like to avoid. Bonus points if anyone knows how this aligns with WCAG a11y requirements.

Setting up IntelliJ in Ubuntu

I wasn’t sure to post here or in the StackOverflow community but here goes…

I have Ubuntu 18.04.3 LTS installed on my laptop. I’m trying to set up IntelliJ at the moment. I installed my jdk by running apt-get install default-jdk which installed java in my /usr/bin/java directory. However, when coding, I am unable to see the source library code in IntelliJ. I only see the decompiled .class files, which isn’t really easy to read, and doesn’t contain any comments.

Basically, my question boils down to: How do I download the openjdk 11.0.3 source code and make intelliJ use that?