Writing data to new database - collation question We will be changing the collation of our databases in a few months. I am setting up an environment, to test the new collation with my application.  I have created a database with our new collation and want to write data into the new database.  Database1: SQL_Latin1_General_CP1_CI_AS Database2: Latin1_General_CP1_CI_AS_WS    If I run the following query:  INSERT INTO Database2.table1 SELECT * FROM Database1.table1   ...will SQL use the collation of Database2 or Database1 to write the data?  Both databases are on SQL Server 2012.  The collation for Database2 is Latin1_General_CP1_AS_WS
Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility' We're moving from SQL 2005 [Instance and DB have collation of SQL_Latin1_General_CP1_CI_AS]  to SQL 2008 [which defaults to Latin1_General_CI_AS].  I completed a SQL 2008 R2 installation, and used default Latin1_General_CI_AS collation, with the restoration of the database still on SQL_Latin1_General_CP1_CI_AS. The excepted problems occurred - the #temp tables where in  Latin1_General_CI_AS whilst the db was in  SQL_Latin1_General_CP1_CI_AS and this is where I am now - I need advice on the pitfalls now please.  On installation of SQL 2008 R2, I have the option on installation to use 'SQL Collation, used for backwards compatibility' where I have the option to select the same collation as the 2005 database : SQL_Latin1_General_CP1_CI_AS.   This will allow me to not have problems with #temp tables, but are there pitfalls? Would I lose any functionality or features of any kind by not using a "current" collation of SQL 2008? What about when we move (e.g. in 2 years ) from 2008 to SQL 2012? Will I have problems then? Would I at some point be forced to go to Latin1_General_CI_AS? I read that some DBA's script complete the rows of complete databases, and then run the insert script into the database with the new collation - I'm very scared and wary of this - would you recommend doing this?
How do I get a Realtek RTL8723BE wireless card to work? Prove that $\langle a^n \rangle \bigcap \langle a^k \rangle = \langle a^{lcm (n,k)} \rangle$ SQL comma-separated row with Group By clause How do I test if all minecraft players on a server are in a radius? This has got me. I need a command that tells me if all players on a server are in a radius of a command block. If one of them isn't in the radius, the command will be false. Any ideas? Thanks! Linear transformation $T:\mathbb{R}^{n}\rightarrow\mathbb{R}^{n}$ such that $T^{2}=\lambda T.$ Let $T$ be a linear transformation $T:\mathbb{R}^{n}\rightarrow\mathbb{R}^{n}$ such that $T^{2}=\lambda T$ for some $\lambda\in\mathbb{R}.$ Then which of the following is/are true?  $1.\|T(x)\|=|\lambda|\|x\|$ for all $x\in\mathbb{R}^n.$  $2.$ If $\|T(x)\|=\|x\|$ for some non-zero $x\in\mathbb{R}^{n}$, then $\lambda=\pm 1.$  $3.T=\lambda I$ where $I$ is the identity transformation on $\mathbb{R}^{n}.$  $4.$ If $\|T(x)\|&gt;\|x\|$ for a nonzero vector $x\in\mathbb{R}^{n},$ then $T$ is singular.  According to me since $T^{2}=\lambda T$ we have $T$ satisfies the polynomial $x^{2}-\lambda x.$ So choices for its minimal polynomial are $x,x-\lambda,x(x-\lambda).$ So $3$rd option is clearly incorrect and $4$th option is not satisfied if $T=I$ and hence correct one. I am confused in first two options . Please help me. Thanks in advance. Rejecting a PhD offer after having accepted it. Advice? I've got an HP Pavilion Touchsmart notebook that came with Windows 8. I've upgraded to 8.1, and now I want to dual-boot an Ubuntu distribution with Windows 10. When dual-booting with Windows 8.1, the Windows Boot Manager always took priority, even after installing GRUB. What do I need to do to get GRUB to be the default bootloader instead of Windows Boot Manager? Height of an HTML select box (dropdown) Can someone confirm that its not possible to change the height of a dropdown that is shown when you click on a select box.   The size attribute of the select makes it look like a list, the height attribute in the CSS doesnt do much good either. Evaluation of $\displaystyle \int_{0}^{1}\frac{x\ln (x)}{\sqrt{1-x^2}}dx$   $\bf{My\; Try::}$ Let $\displaystyle I = \int_{0}^{1}\frac{x\ln x}{\sqrt{1-x^2}}dx\;,$ Put $x=\cos \phi\;,$ Then $dx = -\sin \phi d\phi$  and Changing Limit, We get  $$\displaystyle I = -\int_{\frac{\pi}{2}}^{0}\cos \phi \cdot \ln(\cos \phi )d\phi = \int_{0}^{\frac{\pi}{2}} \ln(\cos \phi)\cdot \cos \phi d\phi$$  Now Using Integration by parts, We get  $$\displaystyle I = \left[\ln(\cos \phi)\cdot \sin \phi\right]_{0}^{\frac{\pi}{2}}+\int_{0}^{\frac{\pi}{2}}\frac{\sin^2 \phi}{\cos \phi}d\phi$$  So $$\displaystyle I = \left[\ln(\cos \phi)\cdot \sin \phi\right]_{0}^{\frac{\pi}{2}}+\int_{0}^{\frac{\pi}{2}}\frac{(1-\cos^2 \phi)}{\cos \phi}d\phi$$  So $$\displaystyle I = \left[\ln(\cos \phi)\cdot \sin \phi\right]_{0}^{\frac{\pi}{2}}+\int_{0}^{\frac{\pi}{2}}\sec \phi d\phi-\int_{0}^{\frac{\pi}{2}}\cos \phi d\phi$$  So $$\displaystyle I = \left[\ln(\cos \phi)\cdot \sin \phi\right]_{0}^{\frac{\pi}{2}}+\left[\ln\left|\sec \phi+\tan \phi\right|\right]_{0}^{\frac{\pi}{2}}-\left[\sin \phi\right]_{0}^{\frac{\pi}{2}}$$  So $$\displaystyle I = \left[\ln(\cos \phi)\cdot \sin \phi\right]_{0}^{\frac{\pi}{2}}+\left[\ln\left|\sec \phi+\tan \phi\right|\right]_{0}^{\frac{\pi}{2}}-1$$  Now How can I solve after that, Help Required, Thanks MySQL: How to retrieve a random row or multiple random rows? Path connected space that is not locally connected I mean a average human can run at his full speed for 15 to 20 mins before getting tired. Trained athletes can go on running for much more time without tiring out.  Do Superheroes like Quicksilver or Flash ever get tired due to excessive running? I tried to follow the new Blender 2.8 tutorial from Blender Guru.   When entering "Sculpting" with the icing there were suddenly alot of holes in it. Why is this? How can I determine accuracy of past probability calculations? I do not study statistics but engineering, but this is a statistics question, and I hope you can lead me to what I need to learn to solve this problem.    I have this situation where I calculate probabilities of 1000's of things happening in like 30 days.  If in 30 days I see what actually happened, how can I test to see how accurately I predicted?  These calculations result in probabilities and in actual values (ft).  What is the method for doing this? Thanks, CP How To Create A 'Two-Sided' Unique Index On Two Fields? How can I efficiently create a unique index on two fields in a table like this: create table t (a integer, b integer);  where any unique combination of two different numbers cannot appear more than once on the same row in the table.  In order words if a row exists such that a=1 and b=2, another row cannot exist where a=2 and b=1 or a=1 and b=2.  In other words two numbers cannot appear together more than once in any order.  I have no idea what such a constraint is called, hence the 'two-sided unique index' name in the title.  Update: If I have a composite key on columns (a,b), and a row (1,2) exists in the database, it is possible to insert another row (2,1) without an error.  What I'm looking for is a way to prevent the same pair of numbers from being used more than once in any order... How to batch import Wavefront OBJ files? Is it possible to batch import Wavefront .obj to blender? I'm working on 2.69. If I select multiple .obj files, only one gets imported. Also if I hit A on file selection window to select all files (.obj and .mtl) I get an error, nothing gets imported. I have to import several hundreds of .obj into the blender file, is this possible? I lock my computer a lot, and was wondering if there was a way to get the lock screen when I hit Ctrl + Alt + L. Right now when I use that key combination it turns the screen black, and I have to hit a key or click to bring up the screen where it shows the option to enter your password or switch users, as well as displaying the desktop background behind it.   Is there anyway to avoid having to hit that extra key, to bring up the screen I want? And is there anyway to keep it that way? It's really a matter of personal preference, and I don't see any reason why not to have it stay that way as my monitor eventually is turned off and/or my computer suspended. Random keys on keyboard stopped working Can we decrypt in this order when the message is encrypted twice? When updating, I get the following error message:   W: The repository 'http://ppa.launchpad.net/mc3man/trusty-media/ubuntu xenial Release' does not have a Release file.   Here, I find another statement on this error:   This recommends removing certain PPAs; and, I'm not sure if I should do that since it might mean not getting the updates that I need.    Is this what I should do?