I have a SQL Server 2012 database which users can attach files to (mainly Jpgs) however the table size is 130mb with only 20 records.   I need to find out which row is using the most amount of space.  The data is stored as varbinary  Thanks
I am trying to determine the size in bytes of the contents in a VARBINARY(MAX) field in SQL Server 2005, using SQL. As I doubt there is native support for this, could it be done using CLR integration? Any ideas would be greatly appreciated.
How to Start Web Mapping? What did Hisoka do in the Hunter Exam? In the first Hunter Exam of the series (Hisoka's second),  was introduced into the series removing another applicant's arms from his body for bumping into him and not apologizing.    What did he actually do? We know Hisoka's abilities are Bungee Gum and Texture Surprise, but they don't explain how the arms are converting into flower petals as seen above. I am trying to create an spritz app. Everything was working fine, but since yesterday I keep getting this error:     ./spritz: line 176: syntax error: unexpected end of file   I have checked the script file and everything seems perfect. I am confused, I have an if statement at last and it looks correct! Here is the last portion:  #checks if speed is 150 157 if [[ $2 -eq 150 ]]; 158 then 159 starttime=$SECONDS 160      FS=$'\n' 161      for j in `grep --color=always -iP '\b[^aeiou\s]*[aeiou][^aeiou\s]*\K[aeiou]' $1`; 162      do 163            #Reads the text file in the centre of the screen 164            echo "                                                    ___________________" 165            echo "                                                             $j"; 166            echo "                                                    ___________________" 167            echo "                                                                               Speed 150 wpm" 168            sleep  0.9; 169            clear; 170       done 171 endtime=$(($SECONDS - $starttime)) 172            echo "You read $words_read words in $endtime seconds!" 173       exit 8 174 fi   What could cause that error? How can I stop Nautilus from dereferencing symlinks? I use symbolic links to tidy my home folder. This works well in the terminal, since the links create the illusion of normal folders:    In Nautilus, however, the links behave more like , immediately teleporting me to their target:    This is particularly troubling when¹ I later want to navigate "up" to the parent folder, as it strands me somewhere outside of the tree I've carefully tidied.  How can I make Nautilus show symbolic links as normal folders, like the terminal does?  Details   Nautilus did not dereference symlinks in Ubuntu 12.10:   Maybe this new behavior is just a bug? I'm not sure how to tell. Here's what I know:   It's not on the . I've skimmed the  and didn't see anything related. The Nautilus mailing list archive . I received no response from about 120 idlers when posing the question on the GNOME IRC channel. A change was made in Nautilus 3.6 to .  ¹ This is an example. A workaround for this particular scenario does not constitute an answer to my question. Since people seem to be interested in discussing it, though:   Using the Back button is not a suitable workaround; it does not always take me to the parent folder. You can navigate up by pressing Alt+Up. The desired behavior in this example is for "up" to navigate to the parent folder of the symbolic link. The current behavior is to navigate to the parent folder of the target of the symbolic link. Wrong Java resource bundle loaded I was born in Brazil and came to the United States at the age of 7, in 2007. I no longer need to live in the United States because I have found success in investing and no longer depend on having a job. I am going to buy property in my home country soon, but I have just turned 18.   Will I ever be able to return to the United States to see my friends and other family members? Even if it is a 30-day visa? And, if so, in the future, am I still eligible for the EB-5 visa? Will I be barred from entry? pdflatex bash script to supress all output except error messages? I have a bash script which I use to compile a file with pdflatex twice (to make sure it sorts out references properly, etc.). This is the 'latexbuild' script I use:  module load ctan pdflatex --shell-escape --interaction=nonstopmode $1 bibtex $1 pdflatex --shell-escape --interaction=nonstopmode --interaction=batchmode $1   I would then call this script with latexbuild test.tex. It produces a lot of output which I would like to supress, except for the error messages which I'd like to see. Is there any way to only allow error messages to be displayed? Is there any well-ordered uncountable set of real numbers under the original ordering? I know that the usual ordering of $\mathbb R$ is not a well-ordering but is there an uncountable $S\subset \mathbb R$ such that S is well-ordered by $&lt;_\mathbb R$?   Intuitively I'd say there is no such set but intuitively I'd also say there is no well-ordered uncountable set at all, which is obviously wrong. I still struggle to grasp the idea of an uncountable, well-ordered set. I'd like to download automatically tons of papers listed on .bib file so I'm trying to find a way to facilitate the process by, e.g. I import or input to a tool a certain .bib file which contains a list of literature, the output is the literature's .pdf file. Any idea to do so? If $k$ is a positive integer, how to prove that there is no solution for $n$ in positive integers except $n = 1$ for $2^n = nk + 1$ How do I list the members of a group? How can I see all the members of a group in Linux? How to name an item using /give command in MCPE? Single service account running all SQL Servers Is there any negative performance impact for using the same service account and agent account to run SQL Server and SQL Agent respectively for all SQL server instances running at a small company of say 35 servers? The biggest database is 0.5 GB. any suggestions are welcome. Thank you. Can I use dispensers or droppers to auto-replant crops? Is there an ingame way to change volume? I like the music, but I still prefer my own music.  Is there an ingame way to change the volume?   I can't find it. How to deal with "java.lang.OutOfMemoryError: Java heap space" error? I am writing a client-side Swing application (graphical font designer) on Java 5. Recently, I am running into java.lang.OutOfMemoryError: Java heap space error because I am not being conservative on memory usage. The user can open unlimited number of files, and the program keeps the opened objects in the memory. After a quick research I found  and others saying on Windows machine the JVM defaults max heap size as 64MB.  Given this situation, how should I deal with this constraint?  I could increase the max heap size using command line option to java, but that would require figuring out available RAM and writing some launching program or script. Besides, increasing to some finite max does not ultimately get rid of the issue.  I could rewrite some of my code to persist objects to file system frequently (using database is the same thing) to free up the memory. It could work, but it's probably a lot work too.  If you could point me to details of above ideas or some alternatives like automatic virtual memory, extending heap size dynamically, that will be great. What is the earliest work considered to be Science Fiction? How do I upload a file to an SFTP server in C# (.NET)? Does a free .NET library exist with which I can upload a file to a SFTP (SSH FTP) server, which throws exceptions on problems with the upload and allows the monitoring of its progress? A group is generated by two elements of order $2$ is infinite and non-abelian I want Ctrl+Alt+B bring up a browser.  Ctrl+Alt+Delete is handy.  Can I set up Ctrl+Alt+B to bring up a browser (either default or specific)?