The Stack Overflow/Super User web application always replaces my backticks with some other code and the backticks are not visible any more in the question. How can I have backticks visible in my questions?
How do I escape a backtick ` within a code block?  This is probably a duplicate, since I'm sure it's a common concern, but I can't find a question that addresses this specifically.  How do I write List'1 with the "1" character still in the code-text format?
Sample query/DDL for producing page locks on a clustered index in SQL Server (without hints) We currently have some indexes where ALLOW_PAGELOCKS is set to off. This presumably was done in order to reduce deadlocks. However I doubt that it would really had an effect back then.   Now I am trying to understand WHEN SQL Server actually chooses to start locking pages rather than keys in a clustered index. I asked Jonathan Keyhaisas recently and he told me that this could happen if I am touching rows on several subsequent pages. However I didn't manage to get any exclusive page locks by updating rows in a clustered index with a sample query.   Could you help me understand page locks better with a sample query and table? I am running SQL Server 2008 SP4.  Thanks in advance  Martin In a PHP5 class, when does a private constructor get called? Let's say I'm writing a PHP (>= 5.0) class that's meant to be a singleton.  All of the docs I've read say to make the class constructor private so the class can't be directly instantiated.  So if I have something like this:  class SillyDB {   private function __construct()   {    }    public static function getConnection()   {    } }   Are there any cases where __construct() is called other than if I'm doing a   new SillyDB()    call inside the class itself?    And why am I allowed to instantiate SillyDB from inside itself at all? Do $T$-invariant subspaces necessarily have a $T$-invariant complement? Programmatically create a user and assign a role I'm programmatically creating a user with the following code.  $newUser = array(   'name' =&gt; $mail,    'pass' =&gt; 'password',  // note: do not md5 the password   'mail' =&gt; $mail,    'status' =&gt; 1,    'init' =&gt; $mail,   'roles' =&gt; array(5) ); $user = user_save(null, $newUser);   I have got a role with the role ID equal to 5; when I create the user, in the table "users_roles" there is only a row with the value 0 for the role ID, but if I print the user object with var_dump(), it looks like the roles are created.  What am I doing wrong? Email SMTP validator I need to send hundreds of newsletters, but would like to check first if email exists on server. It's called  validation, at least I think so, based on my research on Internet.    There's several libraries that can do that, and also a page with open-source code in  (), but I have hard time reading ASP Classic, and it seems that it uses some third-party library...    Is there some code for SMTP validation in C#, and/or general explanation of how it works? How to read from two input files using while loop Change equation font in Pages During a Pages update which was pushed out a few months ago, Pages obtained the ability to write equations using LaTeX or MathML commands. According to an Apple Support article, the size and color of the equation can be changed ():  The equation appears at the insertion point in your document (or before the selected text). The equation is an inline object, the same size and color as the surrounding text. If you change the size or color of the surrounding text, the size and color of the equation’s font also change.  This does not mention anything about the font used for the equation itself, which seems to be something similar to a Times New Roman font. Is there any way to change the font used, preferably to something like Latin Modern Math? I was considering the possibility of replacing the font file Pages uses with a downloaded Latin Modern Math font file, but I'm not sure what to replace. Could I replace Times New Roman in /System/Library/Fonts/ or something like that? I have installed Linux Bash on Windows 10 (available from Microsoft), but I've forgotten my password.  I've searched for a solution but I only find suggestions that involve doing something before the system boots, like accessing recovery mode, but that will not work in this case as this Ubuntu is just an application within a Windows system and doesn't have its own boot process.  How can I reset my password? Combinatorial proof of $\sum_{i = 0}^{n} \binom{i}{r - 1} = \binom{n + 1}{r}$ and then use result to find a formula for $1^2 + 2^2 + \ldots + n^2$ What do you call the functions that make a composite function.  Example : $e^{\sin x} $ is made up of $\sin x$ in the argument of $e^x$  So what are $\sin x$ and $e^x$ called here in this context? Basic functions or something?   (Please don't tell me the former is trig and latter is exponential function, I know that, but that's not what I'm asking here, please try to understand)  Hope I made myself clear. Is it possible to take screenshots on the 3DS? In Pokemon X and Y there are specific locations in the game that allows you to save what are essentially 3D screenshots from the upper screen using a virtual camera. This made me wonder - is it possible to take screenshots, 3D or otherwise, from within the 3DS? Merging dictionaries in C# What's the best way to merge 2 or more dictionaries (Dictionary&lt;T1,T2&gt;) in C#? (3.0 features like LINQ are fine).  I'm thinking of a method signature along the lines of:  public static Dictionary&lt;TKey,TValue&gt;                  Merge&lt;TKey,TValue&gt;(Dictionary&lt;TKey,TValue&gt;[] dictionaries);   or  public static Dictionary&lt;TKey,TValue&gt;                  Merge&lt;TKey,TValue&gt;(IEnumerable&lt;Dictionary&lt;TKey,TValue&gt;&gt; dictionaries);   EDIT: Got a cool solution from JaredPar and Jon Skeet, but I was thinking of something that handles duplicate keys. In case of collision, it doesn't matter which value is saved to the dict as long as it's consistent. Black artifacts when looking through many transparent objects? Using v2.73, cycles and a very simple scene: an array of cubes, no big deal.   If I set the shader's material to transparent, the cubes in the foreground do become transparent but those far away in the back do not disappear completely and this strange dark things appear (visible in rendered mode and in final renders)    I've played with the clipping distance on the viewport and camera, but I can't figure out how to make those ghosts go away... QGIS area calculation differs when on the fly CRS transformation enabled When I open QGIS, add the layer, and calculate the areas of the shapefile via field calculator I get a different area than when I open QGIS and check "Enable on the fly CRS transformation" and calculate the area. This is despite making sure that the project and the layer have the same Coordinate system (same EPSG number). What am I doing wrong?   I have a shapefile with area calculations made with ArcGIS (not be me, the data was handed to me and I have no clue for which CRS the area was calculated with ArcGIS). The shapefile layer CRS is EPSG: 21781 (Switzerland). In QGIS, if I do not change the OTF settings and leave the project CRS as EPSG:4326 (WGS84) I get the same value as the ArcGIS area value. However, if I change the OTF before adding the layer to EPSG: 21781 I get different area values. As I understand this suggests that ArcGIS Area was calculated with the CRS EPSG: 4326.  First workflow:   open QGIS  project CRS: EPSG 4326  add layer  project CRS adapts automatically and is EPSG 21781 now  calculate $area with field calculator    Second workflow:   open QGIS  project CRS: EPSG 4326  Turn on OTF, set project CRS to EPSG 21781  add layer  calculate $area with field calculator    Step 5 of the first and second workflow DO NOT produce the same area. Create ArrayList from array I have an array that is initialized like:  Element[] array = {new Element(1), new Element(2), new Element(3)};   I would like to convert this array into an object of the  class.  ArrayList&lt;Element&gt; arraylist = ???; $f$ holomorphic on $D\setminus \{0\}$ and takes no values in $(-\infty,0],$ then $0$ removable If $f$ is holomorphic on $D\setminus \{0\}$ and takes no values in $(-\infty,0]$ then $0$ is a removable singularity.   I thought to prove this by elimination, but I can't really tell anything about the behavior of $f$ around $0$. How can one translate the information about the definition of $f$ in semi-open interval $(-\infty,0]$. I have read answers to questions like  but I couldn't find a general rule for using "you" or "yourself", "him" or "himself" that could explain things I see in some examples.  For example, I think that one normally say (according to examples I see in ):   You bring something with you. You have something in you. You have something on you. You pressed her to you.   But on the other hand one would say:   You draw attention to yourself. He killed himself. You can try it out for yourself.   As a general rule, it seems that the reflexive pronoun is used when the object is the same as the subject of the verb. But for prepositional phrases, it seems more complicated. Do some prepositions (like "with", "in", "on") always come with the accusative form of the pronoun, and some other (like "for") don't? What about "to", that seems to be followed by both in different circumstances? "ImportError: No module named _struct" configuring python-minimal When I run sudo apt-get upgrade, the dpkg error appears and interupts the process.  Error details:  Setting up python-minimal (2.7.3-0ubuntu7.1) ... Traceback (most recent call last):   File "/usr/local/lib/python2.7/runpy.py", line 162, in _run_module_as_main     "__main__", fname, loader, pkg_name)   File "/usr/local/lib/python2.7/runpy.py", line 72, in _run_code     exec code in run_globals   File "/usr/local/lib/python2.7/compileall.py", line 16, in &lt;module&gt;     import struct   File "/usr/local/lib/python2.7/struct.py", line 1, in &lt;module&gt;     from _struct import * ImportError: No module named _struct dpkg: error processing python-minimal (--configure):  subprocess installed post-installation script returned error exit status 255 dpkg: dependency problems prevent configuration of python:  python depends on python-minimal (= 2.7.3-0ubuntu7.1); however:   Package python-minimal is not configured yet.   And this problem leads to a series of dependency problems when processing the following packages:    python  gwibber-service  libgwibber3  libgwibber-gtk3  gwibber  gwibber-service-facebook  gwibber-service-identica  gwibber-service-twitter  python-all  python-dev  python-all-dev  python-apt  python-problem-report  python-apport  python-libxml2  unity-lens-gwibber  unity-scope-video-remote   Finally, nothing I can do for this problem. And several days later, the root directory is full and I even could not uninstall any software because of this problem. I'm working on a large c++ system that is has been in development for a few years now. As part of an effort to improve the quality of the existing code we engaged on a large long-term refactoring project.  Do you know a good tool that can help me write unit tests in C++? Maybe something similar to Junit or Nunit?  Can anyone give some good advice on the methodology of writing unit tests for modules that were written without unit testing in mind? GRUB and LILO both fail to install to NVMe hard disk when installing Debian