Goal: *Same database to have 2 similiar table named test1 an test2. *Table test2 is only used for query (read only) and table test1 is only used for command (delete, create and update). Background: *Test2 is a replication of Test1 (any changes in test1 should update in table test2 in realtime). Problem: Is it possibly to make a replication of a table in the same database in SQL server? Thank you!
We have a SQL Server 2012 instance that contains a database with data for many product lines.   We are looking for a way to take subsets of this data into another database on the same instance.  This doesn't have to be continuous as we are looking for ways to make it easy to export backups of the subsets that we can send out to vendors (we have a company that loads this data into their own sql server to produce a product we sell, naturally its huge and we want to trim it down to just the product lines they work with on a regular enough basis) or use to load SQLite DB's for use with offline applications.  ProductDB - the superset of all product line data.  ProductLine1DB - A subset identical in structure to ProductDB, but with data only relevant to product line 1.  ProductLine2DB - A subset identical in structure to ProductDB, but with data only relevant to product line 2.  This can be done nightly, weekly, as often as we need to but not a continuous replication.  We don't want to add in distributor servers or even extra subscriber servers. We would like the replication to happen on the same server with the subscriber databases being on the same server.  Is this a good candidate for transactional replication?  Why or why not?  We obviously have other options to load this data, but it seems like this might be a good case to use something like transactional replication. I've heard its powerful but prone to issues when not setup optimally.  Note: I am not a DBA, simply a developer, but we are currently looking for a new DBA and some of us are taking over duties like this temporarily.
Exploiting JavaScript's eval() method Calling Python in PHP I have a Python script I recently wrote that I call using the command line with some options. I now want a very thin web interface to call this script locally on my Mac.  I don't want to go through the minor trouble of installing mod_python or mod_wsgi on my Mac, so I was just going to do a system() or popen() from PHP to call the Python script.  Any better ideas? Thanks in advance! LINQ on a LinkedList - iterate over LinkedListNode, not T Today in the feed on the Android Stack Exchange app there is a Stack Overflow blog post. This post had the site icon next to it for  rather than the proper site logo (Meta).        Stack Exchange Android App Version 1.0.73 and 1.0.74 Android 5.1 on a Moto X (2013) running stock firmware.  Same behavior on a Nexus 7 (flo) running Android 6.0 (stock).  This issue also happens on the iOS app.    The most recent featured SO blog post (as of 17 Nov) is showing up with the "edX" site logo.  The logo is seemingly randomly incorrect. I searched wide and far and couldn't come up with a title for a movie I watched somewhere around the mid-90ies up to early 00's as a rerun in late-night television (in Germany, specifically on Vox; but I'm sure it was an American movie to begin with).  Basically, what I remember from the story revolves around a crew in a space station or maybe space ship of some sort. Some crew members murder other crew members and there is some kind of door they are not supposed/unable to go through. Late in the movie they do go through the door and I'm pretty sure one of the first views is a skeleton of a dead security guard. It turns out the whole thing was some kind of simulation gone wrong and they find themselves to be in a (nuclear?) wasteland. And that's pretty much the revelation/wrap-up of the movie, as I recall it.  I would be delighted if somebody had any idea what movie this could be :) Thanks!  EDIT: The whole movie was in color and I think it was feature-length, not just 45 mins. How can I give a script its own icon in the Unity launcher? With Ubuntu 16.04, if you create a launcher (desktop file in ~/.local/share/applications) with a custom icon for a terminal application (so with Terminal=true) then when you start it, it will spawn a new standard terminal icon, and your custom icon will pulse and disappear within a few seconds.  In 14.04, it just worked as expected. (it would not start a new standard terminal icon).   Any idea what to do to change this behaviour? I have a few terminal apps that I want to launch from unity and the new behaviour is problematic (I lose trace of which is which since they all end up with the standard terminal icon)... Why is it important to apply transformation to an objects data? I've watched several tutorials and very often they applied the location, rotation or scale to the object when they transformed it in Object Mode. They always said it is important, but why? Second order partial of $f(x,y)=\frac{xy(x^2-y^2)}{x^2+y^2}$ Consider the function $f(x,y)=\dfrac{xy(x^2-y^2)}{x^2+y^2}$ for $(x,y) \neq (0,0)$, $f=0$ otherwise.  I have to compute $\dfrac{d^2f}{dydx}(0,0)$.  I know that I have to calculate $\frac{df}{dx}$ first. But that is ,  $\frac{df}{dx} = \frac{\partial f}{\partial y}\frac{dy}{dx}+\frac{\partial f}{\partial x}$. When I put it in wolframalpha, it gives me this calculation, and also just $\frac{\partial f}{\partial x}$ as an alternative form.   Why do I just ignore the y'? I don't know what y(x) is, as a function of x.  y and x are independent functions, no? Subset data frame based on number of rows per group Number of monic irreducible polynomials of prime degree $p$ over finite fields Suppose $F$ is a field s.t $\left|F\right|=q$. Take $p$ to be some prime. How many monic irreducible polynomials of degree $p$ do exist over $F$?   Thanks! Our admins deployed a new version of Notepad++ (version 6.3) on our machines, and this version is highlighting all changes done in a file by default. It does so by setting the background color of every modified line to a bright orange, which I find very distracting.  We  have dozens of plugins installed, but I double checked and we do not have the "Change Markers" plugin (which could be the culprit).  Any idea where I can disable this feature? Changing the highlight color could also be an option. How to run/use popcorn-time? I got popcorn time installed using this link:    But I have no clue how to use or run Popcorn time.  Do I open my torrent client and download a movie and then it gets going? or do I have to open it? If I have to open it, how do I do that, I opened the dash and tried clicking on it but nothing happened. Please help me!! :D Rayleigh-Jeans Law My question is simple, why do we believe  to be absurd? Is the Ultra-violet catastrophe incorrect or is it only because we can not create or know of a perfect emitter? I am a bit confused as to why Quanta was necessary. Can I share my usb keyboard between two computers I love my Filco keyboard, I use it as primary keyboard for my Lenovo thinkpad all time. Now Im moving into the mac world and wonder:  is it possible to split my USB keyboard between two USB ports, ie one at my lenovo and one at my new iMac.   I was thinking that maybe there exists some kind of box with a switch to decide which port should receive the input, or preferable it would be possible to switch between the two via a keyboard shortcut. When does SQLiteOpenHelper onCreate() / onUpgrade() run? "Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset" using PHP SSMS wont give up file associations What's a recommended alternative to Quickbooks pro? I've just installed Ubuntu to replace Windows. I can't seem to find a good alternative to  to run on Ubuntu. Any help would be appreciated. Received an email intended for another person Sort order in Windows Explorer The behaviour described below occurs on Windows-7 systems and on Windows XP. We operate in a dual-language environment - English and Hebrew.  When in Windows Explorer we sort files by name, the order in which they are listed is not what we would expect. Here is a list of file names as sorted by Windows Explorer (all of the files have a .pdf suffix):   1G110033H-PP 19C050G-PP-ORB 19C050H-PPRM 19C100H-PPRM 19C-MBPS-PP 19C-MBPS-PP-1 29AAC050-PP 29AAC100-PP 29AAC100-PPUL   29B004064-PP 101AC050-PP 101AC100-PP 101B100-PPE 1091003G-PPFSUL 10108033G-PPSA 10125033H-PPM     It looks to me that first the items are sorted according to the position of the first alphabetic character in the name, and then, within those groups, they are sorted in "normal" alpha-numeric order.  That is, all the files with an alpha character in the first position are on top of the list, followed by those with the first alpha character in the second position, followed by those with the first alpha character in the third position, and so on.  An alternate way of looking at this is that, in a file name composed of numbers and letters, the sort treats the first group of numbers in the name as the major sort node, with the rest of the name being the secondary sort node.  Now that I understand the sequencing logic, it's not a big problem, but I was wondering why this happens?