What exactly is data.stackexchange.com? I cannot understand, regardless of how much I read about it. It would be helpful if someone explained.
This is the announcement post of the Stack Exchange Data Explorer. Its answers were meant to iron out the initial glitches 6 to 8 years ago.  If you have found a bug or need support  today with any of SEDEs features, please ask a new question and tag it with   What does it do? Allows you to run arbitrary SQL queries on the data dumps, and share those queries with your friends. Technical details It is hosted on the Stack Exchange infrastructure , the database is hosted on the same SQL Server version all other sites are hosted on. You can use most of the TSQL commands, even create temporary objects (but not User Defined Functions). The controls used are jQuery based, the grid is  . All query results are cached, so sharing a link to a query will not result in the server going in to a tailspin. The query edit control is a slightly modified  control, I also am considering bespin cause the inter iframe communication is nasty complicated. It gives up nice syntax highlighting for queries. Parameters There is support for parameterized queries, to get it to work name your params like ##this##. For example have a . Query name and description A query can have a name and description, to name it lead with a comment, to describe it continue commenting, for example: -- This is my query name  -- This is my description -- I can span multiple lines  SELECT 1  Anonymous users can initially name a query, but can not change the names of any existing queries. Tutorial There's a  which helps you getting started in writing your own SQL queries. Logging in You can use your openid provider to log in, at the moment once logged in we will track the list of queries you execute (giving you basic history support) Also if there are any params named UserId they will be populated automatically if your EmailHash matches the one on the site being queried. Magic columns If you alias an id column with as [Post Link] it will automatically create a link in the result set to the parent site. Similarly if you alias an id column with as [User Link] it will display a link to the user page. select top 10 * from Posts will show you how tags are done. (Magic columns for images is planned) example (most controversial posts:  ) So what are you waiting for, check it out at  Any feedback would be greatly appreciated. I hope to have the login section working fairly soon and allow voting on the best queries and commenting. Featured Queries At the moment, admins have permission to feature interesting queries on this page , I am looking for better ways to manage the huge query list that is building up.
I'm working on a new edition of a book which uses a very unusual style of bibliography: Entries are sorted in author-year fashion, but then numbered per author or group of authors, e.g.:  Milnor, J.:    1. Construction of universal bundles: I, Ann. Math., (2)63:272-284 (1956).    2. Construction of universal bundles: II, Ann. Math., (2)63: 430-436 (1956).    3. On manifolds homeomorphic to the 7-sphere, Ann. Math., (2)64: 399-405       (1956).    4. The theory of characteristic classes, mimeographed, Princeton University,       Princeton, N.J., 1957. Milnor, J., and M. A. Kervaire:    1. Bernoulli numbers, homotopy groups, and a theorem of Rohlin, Proc. Intern.       Congr. Math., 1958. Milnor, J., and E. Spanier:    1. Two remarks on fibre homotopy type, Pacific J. Math., 10: 585-590 (1960).   Citations are formatted as Milnor [3], and so on.  Is there any bibtex style for something strange as this? Or can this type of bibliography be created with biblatex without too much coding? I have a sentence that contains a number of long dataset names. I would like to allow LaTeX to break these names at certain positions that I would like to specify somehow just like I can use \- to allow a word break with hyphenation. But: I would like LaTeX not to insert a dash (which could be mistaken as belonging to the dataset name). How can I do this?   (Something similar is realized in the url package so I guess I could just read that code :) I would not like to use the url package here to be able to make a syntactical (and typographic) difference between urls and datset names.) a 2d planet in the center, where the players will be able to walk on it and also will be affected by center gravity. planet will be static and there won't be any other planets. so;  Is there a way that I can change the gravity position? yes you can adjust gravity via project settings but I want it to be in the middle x,y,z(0,0,0)  I have tried creating my own gravity but it wasn't very useful because objects wouldnt fall, stand on foot and also in contact with another object they would vibrate instead of standing still. (if they stand on the planet they would vibrate)          private void FixedUpdate() {     foreach(GameObject item in grav)     {         Attact(item);     } }  private void Attact(GameObject gmf) {     Rigidbody2D rgg = gmf.GetComponent&lt;Rigidbody2D&gt;();      Vector3 direction = rg2d.position - rgg.position;     float distance = direction.sqrMagnitude;      float forceMag = (10 * rgg.mass) / distance;     Vector3 force = direction.normalized * forceMag * 10;      rgg.AddForce(force); }   I can create a script that will change the gravity by the opposite of the object's position. this does work but I cannot see any way to do it for more than one object. My "Meta" rep on Photo.SE differs from my main rep Cleaning my Macbook Pro Retina leaves greasy 'streaks' across the screen Round a double to x significant figures Alert on edit after a downvote I wonder if it would be possible to extend the current notification system.   Namely, if I downvote a question and that thing had an edit, I'd be happy to see that in my inbox. As possibly the cause for downvote was cleaned up and it should be undone. How to limit charging to a user defined limit? My UleFone Armor 2 has a 4700mAh battery and I would like to limit the charging to 60% to reduce battery aging. The batteries in most of the phones are not user-replaceable and I am worried that a factory/service battery replacement might affect water resistance negatively.  How can I limit the charging to 60%? (But not limiting charging speed. I love fast charging.)  Lenovo ThinkPads have a built-in feature that does this, called “battery preservation mode”. Consider numbers of the type $n=2^m+1$. Prove that such an n is prime only if $n=F_K$ for some $ k \in N$, where $F_k$ is a Fermat Prime. Consider numbers of the type $n=2^m+1$. Prove that such an $n$ is prime only if $n=F_K$ for some $ k \in N$, where $F_k$ is a Fermat Prime. Consider numbers of the type $n=a^m-1$ where $a&gt;1$ is a natural number. Prove that such an $n$ is prime only if $n=M_p$ for p-prime, where $M_p$ is a Mersennt Prime.   I do not understand what the question is asking me for. Can I get some clarification? We can apply l’Hôpital’s Rule to the indeterminate quotients $ \dfrac{0}{0} $ and $ \dfrac{\infty}{\infty} $, but why can’t we directly apply it to the indeterminate difference $ \infty - \infty $ or to the indeterminate product $ 0 \cdot \infty $?  Furthermore, why can’t we call $ \infty + \infty $ and $ \infty \cdot \infty $ indeterminate forms?  I’m new to calculus, so please clear up my concepts if you can. Thanks! Is it correct to say "I slump/slumped on/onto the stool/barstool?" I wrote this sentence: "I buy a bottle of beer and slump on/onto the last stool."  A native English speaker told me that "slump" doesn't work here. That you can't slump on a bar/barstool.  Is this correct? If so, why? I already have the pink and red leather gloves, the armor, the crown, and the monkey's staff (and they're all enchanted). Regardless of how many health potions I use, I always die. Help! "Startup Applications" not working I have a simple one line command which works perfectly in terminal, but does not work in the "Startup Applications" app thing.  The line of code is : xmodmap /home/seph/Code/Ubuntu\ Scripts/Xmodmap  It's not that much of a hassle to copy it from "Startup Applications" and paste it into terminal, but I don't really get why it isn't working.  I followed someone else's instructions to do it in the first place, so maybe I did something wrong?  In any case, wouldn't it be the obvious and logical assumption that it just types whatever you put in it into Terminal? I thought it was The Tommyknockers by Stephen King, but after a check with Wikipedia, it appears that's not the case.  What I remember about the story (a TV movie I think, but definitely based on a book) was that the world is created anew every night, and that the old, used up, Earth was eaten nightly by some scary creatures.  The major plot point involved some protagonists not getting onto the new world at midnight, and having to escape from the monsters that were eating up yesterday's planet.  Does this ring a bell for anyone? I'm finding it very hard to Google for. I have forgotten the password or username for my Google account, or I'm unable to access my account for other reasons.  How can I recover my account?  (This Q&amp;A is meant as a general description for all Google and Gmail username/password questions. See: ) Which form should be used for at­tribu­tive nouns like “stu­dent union”: sin­gu­lar or plu­ral, or pos­ses­sive sin­gu­lar or pos­ses­sive plu­ral? I am trying to buy a laptop, and I have seen in many place that they show GDDR3 and sometimes  DDR3. What is the difference between them?  afaik DDR3 is a type of RAM used for system memory, while GDDR3 is a type of RAM used for graphics cards. So does "G" only stand for Graphics or does it have another particular meaning? From the third week ( when does it actually begin) This describes a certain natural process that takes 15 weeks  It describes what a certain component looks like at some point in time during a naturallly occurring process  What I don't get is if it means it appears this way starting in the third week or after ?  Here's the full sentence  "The malleus first appears as a cartilage model from the third week"  Thanks again for you support guys Is it possible to mark or segregate bad blocks on HDD? Hello I want to know if is it possible to mark bad blocks on HDD for OS to not use them. I don't want to save data written on this blocks, just want to get rid of them.  I found some article where author describe how to partition disk to avoid using bad blocks of HDD.  I count how many MB from the start are OK. And also how many MB from end are OK. It looks like I will lost about 50GB of storage space but it is quite fine for me when the disk will run one year more.  First I split disk to 2 partitions:   From beginning to around 190 GB From 190GB to the end   Then I made surface scan of 2nd partition and everything was OK. I was really happy cause i though that finally I will succeed.  Than I wanted to copy all data from 1st partition to 2nd BUT in some data a problem occurs. I/O error. I'd say it is Read problem but when I open file on which copying failed it runs OK, for example some pdf files didn't copied but I opened them.  What can be problem can it be a Write problem? But why there is a problem when surface scan on whole 2nd partition was fine?  What can I do(except buying new HDD)? Can I somehow do this partitioning and use just partition with good sectors? Will it work? How are data stored on the disk? Can I determine where the data will be written? How does the standard error work? I have been looking into the inner-workings of the standard error recently, and I found myself unable to understand how it works. My understanding of the standard error is that it is the standard deviation of the distribution of sample means. My questions are:  • how do we know the standard error is the standard deviation of the sample means when we usually take just a single sample?  • why doesnt the equation to calculate the standard error mirror the standard deviation equation for a single sample?