Using Adodc control to subtract Queries Result
Combine Two SQL queries in one statement
Restore a large number of transaction logs I'm using SQL Server 2008 R2, and I need to restore 36 .trn logs to a database. I have restored the first 4 using the restore transaction log functionality in SSMS (right-click database > tasks > restore > transaction log).   Is there a way to restore them all in order using this tool or with a script? The .trn files are in a folder on a remote server. I do not not need to restore all the files in the folder, only ones between specific dates.  I'm looking for a way to automate this so I don't have to manually restore each individual log.  I access the files using an address like the one below.  \\remote server IP\SQL_Backup\LMSQL02\TLog\file.trn I am new to photography, and need a little advice. I currently have a .   To get rolling, where do I go from here? Does the camera matter? Is this camera enough to start with? Are keywords in URLs good SEO or needlessly redundant? A coworker and I are locked in a debate over the value of SEO keywords in the URL of a page. She wants to change all the filenames of the HTML pages of a fencing company so they look like residential-home-chicago.html, contact-chicago-contractor.html, and so on. She is convinced that because Google highlights keywords in URLs in search results, that means that putting keywords here is more valuable.  My position is that these do not improve SEO, since Google doesn't seem to give keywords in the URL any more weight than keywords in the body of the page, and . In the meantime, they make it harder for me to find the pages I want when its time to edit them, and the site as a whole looks cheap and spammy.   suggests to me that yes, keywords in URLs are useful, but not superior, and that they are more useful for human readability than search engine rankings.  I'm looking for authoritative sources that support either position, not blog articles from SEO optimization companies trying to promote themselves. I would like to know how to put a time delay in a Python script. For a finite set $S$ there are $\vert S\vert!$ orderings of its elements.  What is the cardinality of all orderings of $\mathbb{N}$?  What would $$\vert \mathbb{N}\vert!$$ mean?  Is it $\prod_{n\in\mathbb{N}} \aleph_0=\aleph_0^{\aleph_0}=\aleph_1$?   says the "equivalence classes of well-orderings of the natural numbers" has cardinality $\aleph_1$.  But I can't put together in my mind the connection between well-orderings of $\mathbb{N}$ and all orderings of $\mathbb{N}$.  (Are there non well-ordered orderings of $\mathbb{N}$?)  This leads to wondering what the cardinality of all orderings of $\mathbb{R}$ is.  (Actually my thought process went in the other direction, from $\mathbb{R}$ to $\mathbb{N}$.)  I think knowing the answer to the above question will teach how to determine what $$\vert \mathbb{R}\vert !$$ means, if anything.  I will be happy if you assume the continuum hypothesis to be true for the purposes of this question, but any level of completeness is welcome. Smallest possible triangle to contain a square I was looking at * and started thinking about the case of a polygon with 4 sides: a square.   The question asks for a program that can take a polygon of N sides and return the smallest possible polygon of N-1 sides that contains the original polygon.  Thinking about it, I wasn't sure what the optimal triangle encapsulating a square would look like. In KSab's answers, he returns a triangle that looks like this:    This area is 2*(area of the square). With some easy guess-and-check work I found that this seems to be optimized. How do you prove that there is no better solution?  EDIT: another consideration for the orientation of the triangle could be this: closed form for $\binom{n}{0}+\binom{n}{3}+\binom{n}{6}+...+\binom{n}{n}$ Combining two covariance matrices Is using 15 amp components on a 20 amp breaker against code? Reese's boyfriend seems to constantly be asleep. When I try and talk to him, she warns me that he's been hard at work all night, but I can't actually enter the shop at night.   Is there any way to talk to him or any benefit for doing so? I've tried to talk to him daily for a week (thinking it was something akin to talking to Sable) but I've had no luck. Trying to come in after-hours doesn't work. What happens with lethargy when Haste is cast again on a creature before first cast runs out? Haste states     When the spell ends, the target can't move or take actions until after its next turn, as a wave of lethargy sweeps over it.   However, let's say Character A cast Haste on Character B. In the 10th round (final round of haste if concentration not broken), Character B casts Haste on himself.  What happens during the next round?    Do they lose a round of the "new" haste while they are lethargic and lose movement and actions? Does the new haste override the lethargy until it ends? Is it some combination? Retain AC/Dex modifications but lose actions/movement? None of the above? How does remittance work? How does it differ from direct money transfer? I have a bank account in Germany in which I receive my salary in Euros. I want to deposit a part of it in my Indian bank account for personal savings. My Indian bank account is in INR. As I see it, I have two options:   To use a remittance service that converts my Euros into INR and deposits in my account. I am not sure how it works. The service (which I know is reliable) I signed up for asks me to deposit Euros in a certain account ("funding") which will be converted to INR and deposited in my account. How does that work exactly? Use my bank's service to make a international bank transfer to my account. Is that even possible, given that my Indian account is in INR? Will I incur higher conversion fees and lower exchange rate?   In general, what are the pros and cons of each of the above methods? And are there any other methods? Subtracting from a specific column Is GNOME Terminal a type of non-login shell? Why did the texture I painted in texture paint mode disappear? I want to export my objects to unity, but in blender I`m using Eevee engine. However the light in rendered more and material preview mode is completely different, which impacts the colors of objects. Which one can i trust to see the true final colors of the objects so that they will be the same when i export them to unity? Rich Wizards, Poor Muggles There is a question I have based on the fact: If you take a quadratic polynomial with integer coefficients, take the set $\{1,2,3,4,5,6,7,8\}$, make a partition $A=\{1,4,6,7\}$, $B=\{2,3,5,8\}$, and then evaluate the polynomial with the elements of each set you got an equality.  If now with a cubic polynomial and the set $\{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16\}$, how to pick a suitable partition that accomplish the same fact? I mean is there a general formula for bigger degree? I checked yesterday and today the new homepage in the Android app. Very surprised I saw that I would almost reach a silver tag badge, that confused be because I always take a look on possible badges I can get. However I compared the score with the website and I got a total different results. See this two screenshots: Text not very readable on different image backgrounds I've come here seeking for a bit of design help or advice on how I could possibly improve the following:  Like the title says, I'm having a website banner with multiple text displayed on different images as backgrounds. Now, since most of the images are dark, I've set the font color as white. But even then, some of the text is not very readable on a couple of images like:    Since I'm working with CSS, I've tried different options such as:  Adding Text Shadows:    CSS:  text-shadow: 3px 3px 0px #000;  Also tried, creating a semi-transparent box around the text:      I feel the box one looks out of place.  I've created a  for anyone who knows CSS. If not, please feel free to advice me based on your imagination alone.  PS: You could also advice on using a different font if that would help it stand out better.