I have dozens of text reports that come in every day and I need to store them. I cannot just zip them and put them on the hard drive because the users aren't sophisticated enough to figure that out. I need to be able to associate some data with the report so they can look up report ABC for any given date. These files range in size from 11K to 1GB. Mostly they are less than 3 MB and many are less than 1MB.  What is the best way to store these? The options I am looking at are using Filestream or storing it in a varchar(max) field or zipping it and storing it in a varchar(binary) then unzipping it to display. I am open to any other options as well. Space efficiency is a high priority.   Thank you for reading this. I would truly appreciate any help or advice.  ** The other post is very interesting and I learned a lot from it - thank you for referencing it.  This is different from the other post in that my files are plain text files -- they are not binary files.
What is the best place for storing binary files that are related to data in your database? Should you:   Store in the database with a blob Store on the filesystem with a link in the database Store in the filesystem but rename to a hash of the contents and store the hash on the database Something I've not thought of   The advantages of (1) are (among others) that atomicity of transactions is preserved. The cost is that you might dramatically increase storage (and associated streaming/backup) requirements  The goal of (3) is to preserve atomicity to some degree - if you can enforce that the filesystem you are writing to does not allow files to be changed or deleted, and always has the correct hash as filename. The idea would be to write the file to the filesystem before permitting the insert/update referencing the hash - if this transaction fails after the filesystem write but before the database DML, that is fine because the filesystem is 'faking' being the repository of all possible files and hashes - it doesn't matter if there are some files in there that are not being pointed to (and you could clean them up periodically if you are careful)  EDIT:  It looks like some RDBMSs have this covered in their individual ways - I'd be interested to know how others do it - and particularly in a solution for postgres
How can I set the default terminal used in Unity?  I would like to use the Ctrl+Alt+T hotkey to start a non-default terminal. The default terminal is gnome-terminal.   Where can I change the default terminal value? How to build a dmg Mac OS X file (on a non-Mac platform)? Is it possible to build a .dmg file (for distributing apps) from a non-Mac platform? And if yes, how? Why exactly do sometimes universal covers, and sometimes central extensions feature in the application of a symmetry group to quantum physics? There seem to be two different things one must consider when representing a symmetry group in quantum mechanics:   The universal cover: For instance, when representing the rotation group $\mathrm{SO}(3)$, it turns out that one must allow also $\mathrm{SU}(2)$ representations, since the negative sign a "$2\pi$ rotation" induces in $\mathrm{SU}(2)$ is an overall phase that doesn't change the physics. Equivalently, all representations of the Lie algebra are what we seek. ($\mathfrak{so}(3) = \mathfrak{su}(2)$, but although every representation of the algebra is one of the universal cover, not every representation of the algebra is one of $\mathrm{SO}(3)$.) Central extensions: In conformal field theory, one has classically the  of infinitesimal conformal transformations. From the universal cover treatment one is used to in most other cases, one would expect nothing changes in the quantum case, since we are already seeking only representation of an algebra. Nevertheless, in the quantization process, a  appears, which is often interpreted to arise as an "ordering constant" for the now no longer commuting fields, and we have to consider the  instead.   The question is: What is going on here? Is there a way to explain both the appearence of universal covers and central extensions in a unified way? sql server linked server to oracle returns no data found when data exists Prove $S_4$ has only 1 subgroup of order 12 The subgroup in $S_4$ that I know has order 12 is the subgroup of all even permutations, otherwise known as the alternating group $A_4$. However, I know this from a fact and not because I am able to show a subgroup of order 12 exists in $S_4$ in the first place. If I had not been told there existed a subgroup of order 12 in $S_4$, I would not have known there was one. So I guess this is actually a two-parter for me: 1) How do I go about showing that a subgroup of order 12 does indeed exist in $S_4$? I know by Lagrange that if there exists a subgroup, then the order of that subgroup must divide the order of the group. However, this doesn't say anything about the existence of the subgroup. And Sylow only verifies subgroups of a prime to some power order, which 12 is not. I also know that there might be a cyclic subgroup of order 12, but without manually multiplying every possible permutation in $S_4$, I don't know any other way to check the existence of this or if this subgroup is isomorphic to $A_4$ because I don't know how to write these permutations as functions in order to check if there is a homomorphism (I know that a permutation is bijective by definition). And 2) How do I show that this group of order 12 is the only group of order 12 in $S_4$? I wanted to try out different desktop environments so I installed XFCE, KDE, GNOME, etc on top of Unity in Ubuntu 12.04  After a while I decided that I didn't like those other DEs and would stick to Unity. So I changed my default DE to Unity by configuring gdm.  sudo dpkg-reconfigure gdm   Now I am able to choose my DE at login time and all of DEs are working properly.   But the strange thing is that my boot up screen says 'lubuntu', my login screen is KDE, and my desktop is Unity.   How and why is this happening? Why didn't my gdm configuration have any effect? Does login and boot up screen need to be configured separately from the DE?  There are other similar questions here but they are not the same as this one. I do not want to remove the other enviroments I'm quite happy with having a list of DEs to select from. I want to know how to set proper defaults. SQL to generate a list of numbers from 1 to 100 I have up until Cov(X+Y,X-Y) = E[((X-E(X))+(Y-E(Y)))((X-E(X))-(Y+E(Y)))] and now I am stuck and do not know how this turns into Var(X)-Var(Y) Is a GUID unique 100% of the time? Is a GUID unique 100% of the time?  Will it stay unique over multiple threads? My professor sometimes asks me to referee papers for him.  Should I list the corresponding journals in the professionals activity section of my CV? How do I move Ubuntu dock to bottom on Ubuntu 17.10 and later? Creating new layers using ArcPy to define Definition Query for each field value? I am trying to set multiple definition queries for one layer based on one field using python.  ie.  I have a City layer with a field that holds the city name.  I want a copy of the layer in an MXD with the Definition query set for each value in the City field.  So essentially, I have one source layer, with a copy of the layer as many times as there are values in the City field.  The query would look like this: CITY = 'Atlanta' Pre-print service like arXiv but with private option, so I can correct my mistakes without publicly advertising my mistakes? As a student, I make mistakes all the time, and stealing my idea will not face heavy retaliation. I don't mind if someone comes up with concurrent works, but I do mind if my key idea is leaked. Many graduate students in my field therefore only use pre-print services if their papers are either publicly presented or conditionally accepted. I am looking for a website that can do most of what ArXiv does, with an additional private option or limited visibility, for example an option to make the paper unindexed by search engines. This way, my paper cannot be seen for at least a few months. By doing so, I can at least claim that I am one of the first few researchers who got the idea right. And most importantly, I can privately correct my mistakes, if any. Publishing mistakes is embarrassing and sometimes harms one's career. Many mistakes will be revealed during the peer-review processes and I have a chance to correct them before publicizing. Please kindly think twice before giving ethically and &quot;politically correct&quot; comments like no one will scoop me, everyone will cite me, and the scoopers will be punished. At least in my field, scooping and idea-stealing is commonly observable, and big-names don't care about publicizing pre-prints because they have resources to punish the scoopers. I do understand that keeping my work private might harm the community as the information becomes less transparent. However, it could also be possible that my un-reviewed flawed works misguide the community, and a paper reviewed will benefit the society more. I personally wasted six months because of someone else's mistake in a published work.  I heard that in molecular biology there is a widely-used service to upload your research data, like protein structure and sequencing, to get a timestamp. The uploaded materials can be set to be private for a period, and fully disclosed later. A lot of people do use this function. This is not exactly what I am looking for but shares some similar ideas. If I remember correctly, there is an interesting paper studying the scooping patterns with the aid of this database.  Solutions found!  and some other university-run pre-print services do have an embargo function. Moreover,  is a widely used repository, that, unlike arxiv, only displays the newest version to the general public, although still keeps a tag on the first submitted date! What does this depiction of a black hole in the movie Interstellar mean? I was expecting a whirlpool in 3D and the matter glowing from friction as it nears the center, as I expected a event horizon to be negligible visually.  How does this depiction work? How big is the central sphere? I am puzzled by the perpendicular circles. Are they the event horizons if they are both visible? What would be a path of a particle as it gets swallowed into the singularity? GroupBy a list of associations with their keys Prison problem: locking or unlocking every $n$th door for $ n=1,2,3,...$ I have a problem called "The Prison Problem" that I need to explain to my 9-year-old cousin. I would think that he has just started learning about divisors and perfect squares, and as such, I have a proposed solution. Any input from you guys would be welcome, as to what is the best way to go about this.  Problem:  There was a jail with 100 cells in it, all in a long row. The warden was feeling very jolly one night and told his assistant that he wanted to give all the prisoners a wonderful surprise. While they were sleeping, he wanted the assistant to unlock all the cells. This should be done, he told the assistant, by putting the key in each lock, turning it once. The assistant did this, then came back to report that the job was done. Meanwhile, however, the warden has second thoughts. "Maybe I shouldn't let all the prisoners free," he said. "Go back and leave the first cell open, but lock the second one (by putting the key in and turning it once). Then leave the third open, but lock the fourth, and continue in this way for the entire row." The assistant wasn't very surprised at this request as the warden often changed his mind. After finishing this task, the assistant returned, and again the warden had other thoughts. "Here's what I really want you to do," he said. "Go back down the row. Leave the first two cells as they are, and put your key in the third cell and turn it once. Then leave the fourth and fifth cells and turn the key in the sixth. Continue down the row this way." The assistant again did as instructed. Fortunately, the prisoners were still asleep. As a matter of fact, the assistant was getting pretty sleepy, but there was no chance for rest yet. The warden changed his mind again, and the assistant had to go back again and turn the lock in the fourth cell and in every fourth cell down the row. This continued all through the night, next turning the lock in every fifth cell, and then in every sixth, and on and on, until on the last trip, the assistant just had to turn the key in the hundredth cell. When the prisoners finally woke up, which ones could walk out of their cells?  Proposed solution:  Ten cells are left open after this process. Every cell that is a perfect square will remain open (1, 4, 9, 16, 25, 36, 49, 64, 81, and 100). If a number is not a perfect square, then it has an even number of divisors, therefore it will be "toggled" an even number of times and end up where it started (closed). Perfect squares have an odd number of divisors, so they will end up the opposite of where they started (open). The StackExchange™ MultiCollider SuperDropdown™ says I've got replies, but I've already viewed those $1,000 is pronounced as "one thousand dollars". Reading from left to right, it seems like it would make more sense to write the value as: 1,000$. This way the pronunciation of the value follows the way it's written. Every other numerical value I can think of places the unit after the value:   1 kg 1 L 1 m, etc...   I'm not sure if this question fits in with the rest of the questions on this site. But I'd like to know why currencies are so different from other quantities. Not to mention the need to separate groups of three digits with commas. What is the difference between Newtonian and Lagrangian mechanics in a nutshell? What is Lagrangian mechanics, and what's the difference compared to Newtonian mechanics? I'm a mathematician/computer scientist, not a physicist, so I'm kind of looking for something like the explanation of the Lagrangian formulation of mechanics you'd give to someone who just finished a semester of college physics.  Things I'm hoping to have explained to me:   What's the overall difference in layman's terms? From what I've read so far, it sounds like Newtonian mechanics takes a more local "cause-and-effect"/"apply a force, get a reaction" view, while Lagrangian mechanics takes a more global "minimize this quantity" view. Or, to put it more axiomatically, Newtonian mechanics starts with Newton's three laws of motion, while Lagrangian mechanics starts with the Principle of Least Action. How do the approaches differ mathematically/when you're trying to solve a problem? Kind of similar to above, I'm guessing that Newtonian solutions start with drawing a bunch of force vectors, while Lagrangian solutions start with defining some function (calculating the Lagrangian...?) you want to minimize, but I really have no idea. What are the pros/cons of each approach? What questions are more naturally solved in each? For example, I believe Fermat's Principle of Least Time is something that's very naturally explained in Lagrangian mechanics ("minimize the time it takes to get between these two points"), but more difficult to explain in Newtonian mechanics since it requires knowing your endpoint. the following code will only make the qed not appear in the second proof. However, it it possible to make the qed symbol never appear at the end of the proofs without having to specify it locally every time?  \documentclass{article} \usepackage{amsthm} \begin{document} \begin{proof} This has the QED symbol. \end{proof} \begin{proof}\renewcommand{\qedsymbol}{} This hasn't. \end{proof} \begin{proof} And this has it again. \end{proof} \end{document}