I'm an accidental DBA and need help determining a course of action regarding transaction log files on several databases. I ran Brent Ozar's sp_blitz to see what areas of concern there might be on an instance of SQL Server 2012 and one of the things I saw was transaction log files that are bigger than the data file.  On one database the data file is at 3.33 GB and the log is 5.19 GB. The others have a ratio that's about the same.  The instructions for this scenario indicates that the log file might need to be shrunk, but only if the database is in Full recovery mode. This database is set to Simple recovery.  Should I shrink the log files or just leave them alone?  Thanks for your time.
This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this:  In SQL Server -  What are some reasons the transaction log grows so large? Why is my log file so big? What are some ways to prevent this problem from occurring? What do I do when I get myself on track with the underlying cause and want to put my transaction log file to a healthy size?
How to install .deb file in ubuntu using terminal? I am trying to install Google Chrome,for that I downloaded a google-chrome-stable_current_i386.deb file.  When I try to install using install in terminal   sudo install google-chrome-stable_current_i386.deb  It gives following error.  install: missing destination file operand after ‘google-chrome-stable_current_i386.deb’ Try 'install --help' for more information. I'm attempting to make an elevation profile from a DEM in ArcMap using the Interpolate Line tool.  I've done this before, and it has worked great--basically I just draw a line with Interpolate Line, then click Profile Graph to get the elevation profile.  However, for some reason, it's not working now: when I draw out my line, nothing shows up on the map.  I don't get a line, and I can't figure out what I'm doing wrong.  I've searched online for an answer, but to no avail.    Any tips? The difference between 'credit' and 'accredit'? Both verbs seem to mean the same thing -- to attribute 'X' to Mr. 'Y'. On looking it up, I found:  credit - publicly acknowledge a contributor's role in the production of (something published or broadcast).  accredit - give credit to (someone) for something.  Am I overthinking this, or is there really a difference I should know of? $\lim\limits_{n\to \infty} \int_0^1 |f(x)-a_nx-b_n| dx=0$ implies $(a_n)_n,(b_n)_n$ are convergent Let $f:[0,1] \to \mathbb R$ be a continuous function and the sequences $(a_n)_n,(b_n)_n$ s.t. $$\lim_{n\to \infty}  \int_0^1 |f(x)-a_nx-b_n| dx=0.$$ Prove that $(a_n)_n,(b_n)_n$ are convergent.   I know that $$\left|\int_0^1f(x)dx\right| \le \int_0^1|f(x)|dx.$$ Can somebody help me, please? From the :   -exec command ;     There are unavoidable security problems     surrounding use of the -exec action; you should use the     -execdir option instead.  -execdir command {} +     Like -exec, but the specified command is run from the     subdirectory containing the matched file, which is not     normally the directory in which you started find.  This a much     more secure method for invoking commands, as it avoids race     conditions during resolution of the paths to the matched     files.    What does this mean? Why are there race conditions with running it from the starting directory? And how are these security risks? How do I prove that in every commuting family there is a common eigenvector? I have fish density data that I am trying to compare between several different collection techniques, the data has lots of zeros, and the histogram looks vaugley appropriate for a poisson distribution except that, as densities, it is not integer data. I am relatively new to GLMs and have spent the last several days looking online for how to tell which distribution to use but have failed utterly in finding any resources that help make this decision. A sample histogram of the data looks like the following:   I have no idea how to go about deciding on the appropriate family to use for the GLM. If anyone has any advice or could give me a resource I should check out, that would be fantastic. I tried running the following statement:  INSERT INTO VOUCHER (VOUCHER_NUMBER, BOOK_ID, DENOMINATION) SELECT (a.number, b.ID, b.DENOMINATION)  FROM temp_cheques a, BOOK b WHERE a.number BETWEEN b.START_NUMBER AND b.START_NUMBER+b.UNITS-1;   which, as I understand it, should insert into VOUCHER each record from temp_cheques with the ID and DENOMINATION fields corresponding to entries in the BOOK table (temp_cheques comes from a database backup, which I'm trying to recreate in a different format). However, when I run it, I get an error:  Error: Operand should contain 1 column(s) SQLState:  21000 ErrorCode: 1241   I'm running this in SQuirrel and have not had issues with any other queries. Is there something wrong with the syntax of my query?  EDIT:  The structure of BOOK is:  ID  int(11) START_NUMBER    int(11) UNITS   int(11) DENOMINATION    double(5,2)   The structure of temp_cheques is:  ID  int(11) number  varchar(20) Prove 24 divides $u^3-u$ for all odd natural numbers $u$ At our college, a professor told us to prove by a semi-formal demonstration (without complete induction):   For every odd natural: $24\mid(u^3-u)$   He said that that example was taken from a high school book - maybe I din't get something, but I really have no idea to prove that without using complete induction.  Any idea of smart demonstration?  Thanks for your help. (Excuse my bad English.) Read Gif Images using WebView android What factors influence the spring constant? For certain springs we have been taught that Hookes law, $F=-kx$ works. For such springs, what factors determine k. For instance, k is proportional to length. Can k be expressed in terms of dimensions, mass and other fundemental quantities, or is k a fundemental property of the spring itself? Bit of an issue here, trying to render this glass scene    Looks fine in the viewport, but when I hit render    Does anyone know the cause of different view port and final render, and how to fix it?  Here's my I only have access to the server via a terminal and I can't use graphical tools such as GParted! I want to create a new partition from a part of the root (about 768mb) for swap.  # df -h Filesystem      Size  Used Avail Use% Mounted on /dev/vda         20G  1.3G   18G   7% / udev             10M     0   10M   0% /dev tmpfs           199M  4.9M  194M   3% /run tmpfs           100M   12K  100M   1% /run/user tmpfs           5.0M  4.0K  5.0M   1% /run/lock Windows 10 upgrade assistant stuck at 99% Installed Windows 7 Ultimate (64-bit) on a fresh PC and after installing service pack 1 started the upgrade to Windows 10. The assistant app downloads and verifies but gets stuck at 99% in the upgrading window phase. Even after hours it remains stuck there.  I've tried to reboot the machine and that doesn't help either. I've googled and found out that others have faced the exact problem but so far there isn't any solution that works.  Has anyone seen that situation and is there a fix for it? Proving by strong induction that $\forall n \ge 2, \;\forall d \ge 2 : d \mid n(n+1)(n+2)...(n+d-1) $ How can I generate isometric sprite sheets from 3D animations? Using a diode to ensure current flows in only one direction, without causing a voltage drop To power my microcontroller (ATmega8), I am using a ~5.4V voltage source. I want to ensure that I don't accidentally connect the voltage source in reverse, and figured a diode would be a nice way to accomplish this as from what I have learned so far, a diode allows current to flow in one direction, and blocks it in the other.  But what I also learned is that diodes create drops in voltage. I have a few of the typical diodes (1N4001, 1N4148, etc.), and would like to use them to achieve the aforementioned result without dropping the voltage as it would be too low to power the IC.  My question is, is there any way to do this with a diode? Or do I need some other component (if so, what would you recommend)? How can I change what keys on my keyboard do? (How can I create custom keyboard commands/shortcuts?) Suppose $A$ and $B$ are similar matrices. Show that $A$ and $B$ have the same eigenvalues with the same geometric multiplicities.      Similar matrices: Suppose $A$ and $B$ are $n\times n$ matrices over $\mathbb R$ or $\mathbb C$. We say $A$ and $B$ are similar, or that $A$ is similar to $B$, if there exists a matrix $P$ such that $B = P^{-1}AP$. edges with thickness and color Is there a way to vary the thickness and color of lines created by just edges and vertices? I realize that a face can be defined and then color and material applied, but is there any way to apply a color to the edges?