I have a Big table Which is having monthly Partitions From 01-2013 to 12-2016, I have not created partitions after December 2016.  SQL Server is using Last partition to Insert the data from December,2016.   Can someone help:   Which is the best way to Extend the Partition and move the data of Last partition into Separate Partitions month wise? Create more partitions for future use?   I have a Clustered Index and 3 Non Clustered Index on the Table.  Thanks in advance.
I have a large table that is already partitioned by an identifier (CustomerId). I have created new customers, and want to add new partitions to the table, and want to confirm the correct way to do this. My predecessor set this up and is no longer available so I cannot confirm.  There are currently partitions for 60 distinct CustomerIds (let's say 1-60), and a filegroup and file for each. I have created new filegroups and files for the new customers (61-68) and need to partition the existing data already in this table. So, the data that's already in the table, with customerId 61-68 needs to be moved into separate partitions.   I tried to use the partition wizard, but couldn't find an option for what I wanted. As far as I can tell, I need to run something like:  ALTER PARTITION SCHEME PS_Details  NEXT USED Filegroup61 ALTER PARTITION FUNCTION PF_Details ()  SPLIT RANGE (61)   I'm looking for someone to point me in the right direction as to best practice for this sort of thing. Do I take the data out of the table, into a new table stored in the Filegroup61 then switch the partition in? Not really sure how to approach this.
Connected to wifi successfully, but no internet connection If I'm logged in to a system via SSH, is there a way to copy a file back to my local system without firing up another terminal or screen session and doing scp or something similar or without doing SSH from the remote system back to the local system? On duplicate questions, I often see different headings for the duplicate question list. These include:     Possible Duplicate:    [duplicate question list]   and      This question already has an answer here:    [duplicate question list]   and more recently,     This question is an exact duplicate of:    [duplicate question list]   What decides which heading is placed before the duplicate question list? Height of Water 'Splashing' Suppose from a height $H$, I throw a ball of mass $M$ and radius $R$ with initial velocity $u$ into a pool of depth $x$ having a liquid with density $\rho$ and coefficient of viscosity $\eta$.  Upto what height will the Water Splash?   This may be a silly question! (Source : my brain) Assume every condition to be identical with no air resistance. Feel free to assume any other parameters if needed.  P.S. $\rightarrow$ I've see similar questions but some of them want an exact answer and some are not so direct while some are incomplete questions...  Small Note : We do not have to consider the highest 'single' drop... Just assuming almost every water droplet jumped upto a height $h$. Ideal conditions...  Feel free to assume the liquid as WATER if required! Get full name twice in Bibliography I use biblatex with style=authoryear and when there are two references of the same author in the bibliography there is just a dash. How can I get the full name in the second entry too? Should we pass a shared_ptr by reference or by value? How do I start Chrome using a specified "user profile"? Is it possible to have two Win 10 user accounts running simultaneously, with one used locally and one used via RDP? I need to allow someone to remotely connect to my windows 10 computer, and am wondering if this is possible:  I have two user accounts right now on my computer, one for me to work on and one for my friend remotely. I want to use my user account locally for myself, and I want to allow him to RDP and log into the other account when he needs to work without disturbing my computer experience.   In other words, I don't want to have to stop what I am doing and log off of my user account when he needs to access his account remotely. Can two user accounts run simultaneously in this regard, with one being connected to via RDP?  If so, can you please explain how to set it up properly?  Thanks for your help! I have recently installed lubuntu 11.10 on my old laptop (acer aspire 5315 celeron) and observed that fan is not working properly on lubuntu side.I find it strange that it is working perfectly under window vista.   How could I solve this problem? How to check if jQuery.ajax() request header Status is "304 Not Modified"? Data Dump of Attachments I am trying to do an export of approx 30,000 attachments in our Salesforce Org,  Would anyone have been through a similar exercise and can advise best practice or the best way / tool to do this?  Kind Regards  matt Union of connected subsets is connected if intersection is nonempty How to show the full path of a file or directory in the terminal? I need to know how the directory name in order to type it out in the terminal. How do I access the names of directories?   Windows Explorer used to have a title bar with the full path. Can someone please help me figure out how to see the full path of a certain file? How to install latest Code::Blocks from tar.xz? How to install latest Code::Blocks using codeblocks_17.12-1_amd64_stable.tar.xz?  Software center has an old version and I am not able to configure. How to install? Why is there no documentation for installing? We're given a sequence defined by the recursive relation: $$a_n = \sqrt{a_{n-1}a_{n-2}}$$  $a_1$ and $a_2$ are positive constants. We have to show the following:   The sequences $\{ b_n \} = \{ a_{2n-1} \}$ and $\{ c_n \} = \{ a_{2n} \} $ are monotonic, and if one is increasing, the other is decreasing. The limit of the sequence $\{ a_n \} $ is $ \left(a_1a_2^2\right)^{\frac13} $     Now, I have proved the first part. Besides that, I have also proved a few other things:  If $a_1 &gt; a_2$, then:  a. $ \{ b_n \} $ decreases, and $ \{ c_n \} $ increases.  b. $ c_n &lt; b_n $  If $a_1 &lt; a_2$, we just flip $\{ b_n \}$ and $\{c_n\}$  Besides, I have also shown that both the sequences : $\{b_n\}$ and $\{ c_n\}$ have the same limit. What I don't know, is how to evaluate the limit. How do properties work in Object Oriented MATLAB? How to make a particular app the default viewer / editor for ALL its supported file types at once? Is there a difference between "think of something" and "think about something"? I've also met "have heard of/about something". I'm exploring the effects of removing the intercept in a logistic regression model.  Assume a model:  $$logit(Y = 1) = \beta_1 x + \beta_2z + 0$$  with $x$ and $z$ being categorical variables with 2 levels each and no intercept.  I understood that having no intercept with categorical predictors produce coefficients that compare the $P(Y = 1)$ in each level of the two predictor against a null case where $P(Y=1) = 0.5$ or $logit(Y=1) = 0$.  I noticed a phenomenon that can understand. Using glm() function in R if you change the order of the variable in the right hand part of the formula, the coefficients change too. But even more oddly, the coefficient of the first variable is always the same.  Here's an R demo:  y &lt;- as.factor(sample(rep(1:2), 30, T)) x &lt;- as.factor(sample(rep(1:2), 30, T)) z &lt;- as.factor(sample(rep(1:2), 30, T))  coef(glm(y ~ x + z - 1, binomial) #        x1         x2         z2  #-0.1764783  0.3260739 -0.1335192  coef(glm(y ~ z + x - 1, binomial)) #        z1         z2         x2  #-0.1764783 -0.3099976  0.5025523    As you can see the first predictors have the same coefficient while the other are different in the two models.  Here is what I expected and instead behave differently than what I though:   Since every level of the two predictors is compared to the same null case, I expected to have the same coefficients in the two models, independently from the order in which I use them. I expected to see the coefficients of every level of every predictor, instead the coefficient for the 1 level of the second predictor is not shown. I therefore assume that only the first variable is compared against the null case, while the second is compared against a reference level; but what is this level? Is it $P(Y = 1 | X = 1 \cap Z = 1)$? Reproducing one of the models WITH the intercept we get:  coef(glm(y ~ x + z - 1, binomial) #        x1         x2         z2  #-0.1764783  0.3260739 -0.1335192  coef(glm(y ~ x + z, binomial)) #(Intercept)         x2          z2  #-0.1764783   0.5025523  -0.1335192    As expected x1 become the intercept, and x2 is likely relative to x1. z1 is missing also in this case and z2 is the same as in the model without intercept.  Thus should I assume that the comparison against the null case $P(Y = 1) = 0.5$ is made only for the first variable in a formula, while the other are compared against the usual intercept? Is this behavior normal? What about the fact that the first coefficient has the same value whichever the order of the predictors in the formula? What if I want to compare all level of each predictor against the null case and have a coefficient for all levels? Or it's theoretically impossible for some reason I don't get? How do malloc() and free() work?