how to remove all but top 10 records from database sql server 2012? Of course I know I can issue delete statement for each table in DB but my question is  there any trick to do this automatically with one statement or not really. I have  large amount of data and for testing purposes I need a shrunk version os DB. top 10 records only will be fine.
Delete all but top n from database table in SQL What's the best way to delete all rows from a table in sql but to keep n number of rows on the top?
Inheriting from a UserControl in WPF I am fairly new to WPF and I am having a problem with inheriting from a user control.  I created a User Control and now I need to inherit from that control and add some more functionality.  Has anyone does this sort of thing before?  Any help would be greatly appreciated.  Thank you Why is $SO(3)\times SO(3)$ isomorphic to $SO(4)$? Area51 proposals are being advertised now all over the network? Array with labeling columns Is there an intelligent way to label (or name) columns in a matrix? I would like to have something like  \[M=\left[\begin{array}{c|cc} 1 &amp; 2 &amp; 3\\ 4 &amp; 5 &amp; 6 \end{array}\right],N=\left[\begin{array}{c|cc} 7 &amp; 8 &amp; 9\\ 10 &amp; 11 &amp; 12 \end{array}\right]\] \[A \ B \ C \ D \ E \ F\]   where A, B,..., F are the labels (or rather names) of the first, second, ..., sixth columns, respectively. What I want is to label A be exactly below the first column, label B be below the second column, etc., of course, nicely aligned. So far I have forced some extra spaces before the labels manually, and also experimented with the \phantom command. example of not surjective isometry on a bounded not closed set. Exponential of the differential operator I am not sure whether this question is even well-posed. But today I learnt that $e^Df(x) = f(x+1)$ where $D$ is differential operator and  $$e^D \triangleq \sum_{i=0}^{\infty} \frac{D^i}{i!}.$$  (ref. )  So I was curious as to whether the differential equation  $$\frac{df(t)}{dt} = e^Df(t) = f(t+1)$$  has any solutions apart from $f = 0$? What is crop factor and how does it relate to focal length? I'm reading that a 50mm lens is recommended as a first prime lens for DSLR owners as it's supposed to give a 'natural' perspective, but when used on (most) DSLRs, the view is cropped, as if you were zoomed in by 1.5-1.6x, so it's more of a telephoto lens when used on a DSLR. I've also read however that the 50mm lens gives the same perspective on a DSLR and a 35mm, and shouldn't really be considered to be 'equivalent' to an 80mm lens as the crop factor isn't really a magic focal length changer.  Can someone explain how the image is different from (for example) a 50mm lens on a DSLR and an 80mm lens (assuming 1.6x crop factor) on a 35mm camera? Question of an isomorphism of $\epsilon_ 0$ and a subset of the rationals. Plotting heat equation in a Manipulate expression Why my differential equations become True? Is it possible to write a template that changes behavior depending on if a certain member function is defined on a class?  Here's a simple example of what I would want to write:  template&lt;class T&gt; std::string optionalToString(T* obj) {     if (FUNCTION_EXISTS(T-&gt;toString))         return obj-&gt;toString();     else         return "toString not defined"; }   So, if class T has toString() defined, then it uses it; otherwise, it doesn't. The magical part that I don't know how to do is the "FUNCTION_EXISTS" part. Commutator subgroup and cyclic normal subgroup Uploading an image from the web can leave paste broken in editor How long would the conference be for? I want to know if this is grammatically correct " How long would the conference be for?". TikZ: remove margin, padding, border around nodes containing images I want to create a simple figure where images are connected with arrows. Here is what I did:  \begin{tikzpicture} \node[](A) {\includegraphics[width=0.2\textwidth]{a}}; \node[right=1mm of A](B) {\includegraphics[width=0.2\textwidth]{b}}; \draw[-&gt;] (A) to (B); \end{tikzpicture}     But I want the arrow to start and end right at the images with no space between. How can I do that? New three-tiered badge idea: Explainer →Refiner → Illuminator The difference between a poor or meh question and a stellar question can often simply be someone understanding it and providing it a great answer. I can't begin to count the number of times I've justified re-opening a question as a moderator by saying:     Look at the answer it got, though. This isn't something we want deleted, this is something we want fixed, because it's obviously valuable. Someone with domain knowledge can easily edit that question based on the answer it received.   This doesn't only apply to borderline-poor or poor questions – sometimes a good edit means the difference between 100 and 10,000 people finding something through typing things into Google. Good titles are hard.   We think we've come up with a way to provide incentive for good, opportunistic edits to happen more often, ideally without questions needing to go through closure or collecting a centimeter of dust before they do. What if we simply rewarded folks that answered and edited questions with a special, relatively difficult to earn badge?  Let's say that you answer something, and:   You edit the question 12 hours before or after answering it. This allows you to edit now, answer later &mdash; or answer now and edit later, when you have the time. Your edit isn't rolled back, or outright rejected if it was a suggested edit The question is not closed for any reason, even simply being a duplicate Your answer has a score of 1 or higher   &hellip; then you've done something that we probably want to recognize. You understood something, you provided the knowledge that you have, and then you provided an edit to make sure that more people in need of this knowledge can find it, while raising the overall quality of the site.  Here's the proposed tiers for the badge (within the above stated criteria):   Explainer (Bronze): Answered &amp; edited 10  questions Refiner (Silver): Answered &amp; edited 50 questions Illuminator (Gold): Answered &amp; edited 500 questions   We think this is going to be pretty hard to game. You can't go leaving streaks of terse snark all over the place on questions you know are going to be closed anyway, and junk edits aren't going to fly.  We're talking about rewarding folks that take a tiny bit more time out of their day just to write a more descriptive title so that folks can find the awesome answer that they wrote. Just doing that alone can make a big difference. Sure, it's a tad hard to get at the gold level, but it's supposed to be. If you routinely edit questions that you answer and have done so for some time, you'd probably get it the day we roll it out.  While this is technically something that we came up with on the quality initiative ( | ) &mdash; this badge could be earned on all of our sites.  What do you think? What did we miss? What could be better about the idea? Find $\lim_{x\to 1}\frac{p}{1-x^p}-\frac{q}{1-x^q}$ Find $\lim_{x\to 1}(\frac{p}{1-x^p}-\frac{q}{1-x^q})$    My attempt: I took LCM and applied lhospital but not getting the answer.Please help How can i check if $remote_addr IP is NOT in CIDR range in nginx? I am using nginx latest web server. How can i check if the $remote_addr ip is NOT in specified CIDR range and return appropriate error code.  i would like to return specific error codes if IP is NOT in specific CIDR IP ranges.  how can i do this for CIDR IP range ?  e.g.    If remote_addr is not in 123.123.123.123/24 then return 444 code . How do I install the Nvidia drivers? I just ordered the Nvidia GTX card. I have a dilemma, though. Should I keep using the driver which is available in "additional drivers" in Ubuntu, or should I install the driver from the Nvidia site?  So which driver is the best for me? How to copy text out of a PDF without losing formatting?