We need to upgrade two SQL Servers for our projects to SQL Server 2012. Since we’re not db-admins or familiar with such migrations, I wanted to ask you if you could tell me what we have to be aware of and check before upgrading.  Some information about the servers:  Project 1:   SQL Server 2008 No procedures No functions No views   I think this should not really be a problem to upgrade to 2012 right? Is there anything else we have to make sure?  Project 2:   SQL Server 2005 ~700 procedures ~50 functions ~100 views   I think this will be more of a problem… is there any logic that won’t work on SQL Server 2012 that did on SQL Server 2005?  Is there a list of keywords which are not supported anymore?  Are there other problems that could happen during / after the migration?  Thanks in advance
I have recently upgraded SQL Server 2000 database to 2008 R2.    What I did was:   Shutdown SQL Server 2000 (express) service on old machine, Move datafiles (mydatabase.mdf and mydatabase.ldf) to new machine, Run SQL Server Management Studio 2008, Connect to local database engine, Attach datafiles to database. Change the compatibility level of database to SQL 2008 (100).     Question: What else should I do to make migration complete?  I want to:   use new features like checksumming and full recovery model, make this database to be exactly as it was created in SQL 2008 R2, make this database to be fully compatibile, correct and be perfect suited for new, SQL 2008 R2 database engine.     In other words: I just want to know how to correctly and completly convert old SQL 2000 database to new 2008 R2 database, be calm that everything is done right and be happy with all new features.    I'm asking this question, because I've found a lot of sites on the Internet that says so many different things that makes me confused: some say that it is required to rebuild indexes, another says to do other things... and now I know nothing so I want to hear experienced person opinion and clear, step-by-step instructions. I work for very small company, I'm on my own and I don't want to screw things up.    Sir, I'm really impressed with your answer, I wasn't expecting so much.    So some comments:   The database is now in production. As I said, it was upgraded using deattach-attach method as I desribed in first post and as described on MSDN:  It had to be done quickly, so I was forced to do it that way. Let's forget about how inappropriate could it was and focus on current situation. The users/persmission is not a problem here - there are only few and permissions are simple. The application which use database is compatibile with SQL 2000 till 2012 so this is not a problem either. The database file (MDF) isn't big - only about 1GB.     Few more questions:   You recommend to use backup/restore method, but I did as written above, so can I encounter any problems now? Everything worked without any problem. About checksumming and full recovery model: it wasn't available/enabled on SQL 2000, so I want to use them now. You said that the only thing I need to do is to enable those options in database properties? I've read somewhere, that it isn't enough and I should also rebuild indexes or something. I really don't know, I just asking. I'm prepairing to migrate this database to SQL 2012 - so first it was from SQL 2000 to 2008 R2, now it will be from 2008 R2 to 2012 (it was impossible to do this directly because of lack of support of SQL 2000 databases in SQL 2012). So I understand that I should follow your guide: backup it in 2008 R2 and restore in 2012, then do the rest of your tips, right? Please explain me the backup/restore method: Is it like a dump of database to SQL queries and then restoring it by executing a bunch of queries? Will this method by the way "defragment" my database? If not, how to defragment/optimize it manually? As we were using SQL 2000 Express for years (no management interface), we were doing backups simply by stopping engine and RAR the DATA directory. For now, as we are on SQL 2008, isn't this still better than using backup function in Management Studio? Full recovery mode with frequent Transaction log backups - Where is the Transaction log stored - is it the LDF file? How sould I backup it properly?     I know that my questions may sound silly, I'm not professional database admin, but I am the only person here who can do such "hard core" task like upgrading the database engine. I'm also sure that your knowleadge will help a lot to other people like me.  Thank you very much for your time and knowleadge, I really appreciate this.
I'm trying to figure out how to send all information that is normally identified in the /var/adm/message file on a Solaris system to a remote system. How does "curved space" explain gravitational attraction? They say that gravity is technically not a real force and that it's caused by objects traveling a straight path through curved space, and that space becomes curved by mass, giving the illusion of a force of gravity.  That makes perfect sense for planetary orbits, but a lot less sense for the expression of gravity that we are the most familiar with in our day-to-day lives: "what goes up must come down."  Imagine that I hold a ball in my hand, several feet off the ground, with my fingers curled around it, and my hand is above the ball.  Then I open my fingers, releasing my grip on it, being very careful to not impart any momentum to the ball from my hand as I do so.  An object at rest remains at rest unless acted upon by an outside force.  If the ball is not moving (relative to my inertial reference frame), it has no path to travel that's any different from the Earth's path through space.  It should remain at rest, hanging there in the air.  And yet it falls, demonstrating that an outside force (gravity) did indeed act upon it.  How does curved space explain this? What is the correct way to install proprietary ATI Catalyst Video Drivers (fglrx) directly from AMD? I am planning on doing a fresh install of Ubuntu and want to know what is the correct way to install ATI Catalyst Video Driver?      There are multiple valid answers for this question spanning over several versions of Ubuntu. For your convenience an index of each below: Travelling to India via Germany with 2 stops, do i need transit visa? I have Indian passport and USA H1 valid visa, will be travelling US and my itinerary is Mumbai – Munich – Frankfurt – San Francisco. This route has two stops in Germany, Munich – Frankfurt is German domestic flight. I am not sure if I would need a Schengen or Transit Visa. I was going through few German and Indian consulate visa website but I am not able to get the correct info, specially below two statements are confusing. Could you please help me with this?    In these five airports in Germany you can stay at the International Transit Area without a visa: 1.  Cologne/Bonn 2.  Düsseldorf 3.  Frankfurt/Main 4.  Hamburg  5.  Munich  Airport transit privilege does not apply in the following cases and you will need to get a visitor visa if: You are transiting through two or more airports in the Schengen Countries Why can we treat quantum scattering problems as time-independent? From what I remember in my undergraduate quantum mechanics class, we treated scattering of non-relativistic particles from a static potential like this:   Solve the time-independent Schrodinger equation to find the energy eigenstates.  There will be a continuous spectrum of energy eigenvalues. In the region to the left of the potential, identify a piece of  the wavefunction that looks like $Ae^{i(kx - \omega t)}$ as the incoming wave. Ensure that to the right of the potential, there is not piece of the wavefunction that looks like $Be^{-i(kx + \omega t)}$, because we only want to have a wave coming in from the left. Identify a piece of the wavefunction to the left of the potential that looks like $R e^{-i(kx + \omega t)}$ as a reflected wave. Identify a piece of the wavefunction to the right of the potential that looks like $T e^{i(kx - \omega t)}$ as a transmitted wave. Show that $|R|^2 + |T|^2 = |A|^2$.  Interpret $\frac{|R|^2}{|A|^2}$ as the probability for reflection and $\frac{|T|^2}{|A|^2}$ as the probability for transmission.   This entire process doesn't seem to have anything to do with a real scattering event - where a real particle is scattered by a scattering potential - we do all our analysis on a stationary waves.  Why should such a naive procedure produce reasonable results for something like Rutherford's foil experiment, in which alpha particles are in motion as they collide with nuclei, and in which the wavefunction of the alpha particle is typically localized in a (moving) volume much smaller than the scattering region? Is $R^2$ useful or dangerous? I was skimming through  by Cosma Shalizi (in particular, section 2.1.1 of the ), and was reminded that you can get very low $R^2$ even when you have a completely linear model.  To paraphrase Shalizi's example: suppose you have a model $Y = aX + \epsilon$, where $a$ is known. Then $\newcommand{\Var}{\mathrm{Var}}\Var[Y] = a^2 \Var[x] + \Var[\epsilon]$ and the amount of explained variance is $a^2 \Var[X]$, so $R^2 = \frac{a^2 \Var[x]}{a^2 \Var[X] + \Var[\epsilon]}$. This goes to 0 as $\Var[X] \rightarrow 0$ and to 1 as $\Var[X] \rightarrow \infty$.  Conversely, you can get high $R^2$ even when your model is noticeably non-linear. (Anyone have a good example offhand?)  So when is $R^2$ a useful statistic, and when should it be ignored? How do you square an ideal? For some of you, this question is going to seem extremely basic.  I think I understand what an ideal is. Such as $\langle 2, 1 + \sqrt{-5} \rangle$, it consists of all numbers in this ring of the form $2a + (1 + \sqrt{-5})b$.  But then what is $\langle 2, 1 + \sqrt{-5} \rangle^2$? My first thought was $\langle 4, -4 + 2 \sqrt{-5} \rangle$, but that seems wrong somehow. I also had something in the back of my mind saying $\langle 2 \rangle$, but I'm not sure about that one either.  Then I thought about trying to figure out $\langle 2, 1 + \sqrt{-5} \rangle \langle 2, 1 + \sqrt{-5} \rangle$ when I realized I don't actually understand how to multiply ideals to begin with.  I'm only using $\langle 2, 1 + \sqrt{-5} \rangle$ as an example (though that does draw in one question identified as similar that looks much more relevant than all the questions identified as "Questions that may already have your answer"). In a principal ideal domain, would it be correct to think that $\langle a \rangle \langle b \rangle = \langle ab \rangle$?  Any help would be much appreciated. I have 2 quartz crystal resonators in my pcb board: 32.768 kHz &amp; 20 MHz. They are connected to a Freescale MC12311 transceiver IC, which has an HCS08 micro-controller embedded in it. I want to test if these crystals are working properly or not.  Available tools: Oscilloscope, Frequency-Meter (Digital Counter), Digital Multimeter.  How should I use these tools to test the crystals in board?   Note: The capacitive load-effect of probes should probably be considered. If not, the measurement would not be accurate, or even worse, the crystals would not work at all.     Edit1: I used both the oscilloscope and the frequency-meter (with x10 probes), but unfortunately there was nothing monitored at all. Dividing polynomial $f(x)$ by $x-3$ and $x+6$ leaves respective remainders $7$ and $22$. What's the remainder upon dividing by $(x-3)(x+6)$? selectively make contact groups silent How to effectively deal with Imposter Syndrome and feelings of inadequacy: "I've somehow convinced everyone that I'm actually good at this" If $d(x,y)$ is a metric, then $\frac{d(x,y)}{1 + d(x,y)}$ is also a metric Let $(X,d)$ be a metric space and for $x,y \in X$ define $$d_b(x,y) = \dfrac{d(x,y)}{1 + d(x,y)}$$ a) show that $d_b$ is a metric on $X$  Hint: consider the derivative of $f(t)$ = $\dfrac{t}{1+t}$  b) show that $ d$ and $ d_b $ are equivalent metrics. c) let $(X,d) $ be $(\mathbb{R}, |\cdot|)$ Show that there exists no $ M&gt;0$ such that $ |x-y| $ $\leq$ $Md_b$ $(x,y)$ for all $ x,y$ $\in$ $\mathbb{R}$  I have calculated $f(t)$ and $f'(t)$ and from this I know $f(t)$ is an increasing function as $f'(t)$ is strictly positive. But I don't know where to go from here or how to do parts b) and c) Closure of a Ball is Contained in Closed Ball (usual metric) Let $\overline{B_d (x, r)}$ be the closure of an open ball, and let $\hat B_d (x, r)$ be a closed ball. Show that in any metric space $(X, d)$, $\overline{B_d (x, r)} \subseteq \hat B_d (x, r)$ for all $x \in X$ and $r &gt; 0$.    I used the definition of closure: $\overline{B}$ = $B \bigcup B'$. If $x \in \overline{B}$, then $x \in B$ or $x \in \overline{B}$, or both. If $x \in B$, then clearly $x \in \hat B$ since $B \subseteq \hat B$. But, if $x \in B'$, then $x$ is an accumulation point. Since $\hat B$ is closed, it contains all accumulation points of $B$. Thus, $x \in \hat B$.  Is this approach correct, or at least in the right direction? Should I be using the closure definition, or try another one? Thank you. When adding NOT NULL columns with a DEFAULT value - does PostgreSQL optimize this operation?  In case the table has n rows, a not-optimized alter-table-add-column would yield n writes of the default value - which could be very painful, obviously. With the optimization the DB would instantaneously create the new column, store just one copy of the default value which would be returned when no non-default value is found for that column in a suitable index data structure.  For example  such an . Questions like:   ♦ ♦-should-discriminate-more-when-bumping-unanswered-questions ≠-users-who-want-to-write-good-posts   well, you can see there.  The diamond (and other problematic Unicode characters) in the title breaks the automatic prettification of internal question links.  This becomes a bit more of an issue when one wants to link to an answer.  For example ♦-break-the-automatic-hyperlink-parser/242572#242572 should link to Martijn's answer, but, it doesn't (tangent, but a different issue is that  which is the share link doesn't auto-prettify unless the userid part is removed - one keeps having to manually remove things to get the auto prettify to engage).  If one looks at the html generated for  for the title and the url linked in the &lt;h1&gt; of the page, we get:  &lt;title&gt;Users who can&amp;#39;t write good posts ≠ users who want to write good posts - Meta Stack Exchange&lt;/title&gt;     &lt;h1 itemprop="name"&gt; &lt;a href="/questions/238644/users-who-cant-write-good-posts-%e2%89%a0-users-who-want-to-write-good-posts" class="question-hyperlink"&gt;Users who can&amp;#39;t write good posts ≠ users who want to write good posts&lt;/a&gt; &lt;/h1&gt;   And while that's a long link title, I will point out that the quote as part of the word "can't" was removed from the slug.  The bug is that this should be done for other characters too. I want my Java code to be typeset in a monospaced font, so I am using the verbatim environment. LaTeX commands are highlighted in Eclipse, but as soon as I use the verbatim environment everything inside and the color of the environment itself becomes gray.  \begin{verbatim}   public class main {  public static void main (string[] args){      for(int i = 0; i &lt; arg.length; i ++){          System.out.println(args[i]);      }    }  };  \end{verbatim}   I'm using the verbatim and alltt packages.  Update 1.  MWE.  \documentclass[xcolor=dvipsnames]{beamer}  \mode&lt;presentation&gt; { \usetheme{CambridgeUS} \setbeamercovered{transparent} }  % Поддержка русского языка \RequirePackage[utf8]{inputenc} \RequirePackage[T2A]{fontenc} \RequirePackage[russian]{babel}  \RequirePackage{amsfonts}  \usepackage{algorithmic} \usepackage{mathptmx} \usepackage[scaled=.90]{helvet} \usepackage{courier} \usepackage{pst-node} \usepackage{pst-tree} \usepackage{auto-pst-pdf} \usepackage{color} \usepackage{colortbl} \usepackage{pstricks} \usepackage{verbatim} \usepackage{alltt} \usepackage{listings} \usepackage{animate} \usepackage{multimedia}  \title{Title}  \author{Name}  \institute{}  \date{\today}  \begin{document}  \begin{frame} \titlepage \end{frame}  \begin{frame} \frametitle{Outline} \tableofcontents \end{frame}  \section{Introduction}  \begin{frame}{Классификация по поколениям}  \begin{itemize}  \item Третьего поколения (высокоуровневые языки) - последовательность высокоуровневых конструкций (циклы, условные выражения, классы, интерфейсы, методы, процедуры, \ldots) \pause  \begin{exampleblock}{Пример}  \begin{centering}  Fortran, C, C++, C\#, Java, Lisp.  \begin{verbatim}  public class main { public statiс void main (string[] args){ for(int i = 0; i &lt; arg.length; i ++){ System.out.println(args[i]); } } };  \end{verbatim}  \end{centering}  \end{exampleblock}\pause  \item Четвертого поколения (для конкретного применения) - последовательность инструкций конкретной предметной области \pause  \begin{exampleblock}{Пример} SQL, Postscript, XML, Mathlab. \end{exampleblock} \pause  \end{itemize}  \end{frame}  \end{document} In Helgason, "Differential Geometry, Lie Groups and Symmetric Spaces"  we have the formula for the exterior derivative  $(p+1)d\omega(X_{1}, \ldots X_{p+1})=\Sigma_{i=1}^{p+1} (-1)^{i+1} X_{i} \cdot \omega(X_{1}, \ldots , \hat{X_{i}}, \ldots X_{p+1})+\Sigma_{i&lt;j} (-1)^{i+j}\omega([X_{i}, X_{j}], X_{1}, \ldots , \hat{X_{i}}, \ldots \hat{X_{j}}, \ldots , X_{p+1})$  but in other sources on-line they have the same formula without the factor of $p+1$ on the left-hand side.  Are there two different definitions of the exterior derivative, or is there an error in Helgason? Use the definition of derivative to prove $\lim_{x\to 0}\ln(x+1)/x =1$ How would I use the definition of derivative to prove  $$\lim_{x\to 0} \frac{\ln(1+x)}{x} = 1$$  I got to $$\frac{\frac{\ln(1+x+h)}{(x+h)} - \frac{\ln(1+x)}{x}}{h}$$ but have no idea where to go from here.   On another site I found someones answer where they stated the following: $$ \lim_{x\to 0} \frac{\ln(1+x) - \ln(1+0)}{x-0}  = [\ln(1+x)]'\rvert_x = 0 $$ but I am unsure why the $x$ in the $x-0$ is removed. Can someone please explain? Direct Link to a Comment The increase in the character limit of comments has led them to become as important as the questions and answers that spawn them. On several occasions (especially on meta) I've found reason to want to link to a comment directly. I'd imagine something as simple as making the date / time stamp an anchored link which mimics the behavior of the question link. I applied a survey consisting of 12 questions to 120 people and each questions include 4 nominal categories; I want to make comparison of people's answers according to their socio-demographic characteristics such as their educational level or socioeconomic status. All of my comparison criteria consist of nominal categories and number of categories change between 3 to 6. I cannot drop or combine comparisons; categories in other words number of categories are fixed.    My question is when I compare the frequency distribution of people's answers based on their education levels (for example) through chi-squared test, I got a warning that says (for instance) 7 cells have less than count five; minimum expected count is; 43.  I got this warning for almost my all questions - demographic characteristics comparisons.    Shall I underestimate this warning and use my test results or is there a different test I should use? If I should use a different test, which one?