Forgot to say I'm using SQL Server 2102 SP2 Enterprise Edition. @AaronBertrand you are, as ever, correct. Your second 'this post' mentioned solved my issue. If you want another green tick, add your comment as an answer — DiamondBeezer17 hours ago
top of my screen. We moved the crypto chat to slack out of courtesy. Do I want to read "says the guy who calls a bloated inefficient clusterfuck a "SQL Server."" and other such gems.
So this question already had a tag visual-studio . Suggested edit was to add tag visual-studio-2017 (yes, it is mentioned in the question). MdHaidarAliKhan and JJussi reviewed and suggested to add the tag. Is that a substantial edit?
I did the same for this one, approved by the same two people. It did seem to me more a response than an edit but in the end it was difficult to determine from reading the post itself.
@AndriyM Well the last image was broken, and the language wasn't great. I fixed those up. I guess the author of the answer can judge if it's a good addition or not.
@gbn I hadn't really noticed, to be honest.
Chat participation in the heap has always been a bit variable.
SSMS 2017 has a "vulnerability assessment" menu item for each database; it returns this "failed" security check about the DAC:
> The Dedicated Admin Connection (DAC) is intended to be used by administrators for troubleshooting in scenarios when normal connections are not available due to an abnormal state of the system. For scenarios, other than clusters, the DAC is intended to be used only on the same node, and not remotely, to prevent automated attacks against this entry point.
isn't that a bit stupid? I mean wouldn't you really want to have it enabled for remote access in case the server is so busy you cannot even login to it?
Otherwise it supports target names with up to three parts (you can't merge into a table at a remote server using the four-part notification), according to the manual.
I'm on macOS primarily (and have been for 10 years), but I have 2 Windows VMs that I use for SQL Server (though SQL Operations Studio is getting there), and <3 Unix
Did you try this?: update x_addr_table1 a set email1 = ( select T2.email1 from x_addr_table1 as T2 where T2.emp_id = a.emp_id and T2.isprimary = 1 ) where a.isprimary = 0 ; — ypercubeᵀᴹ1 hour ago
@ypercubeᵀᴹ I think they also want to skip the rows where the email already matches the primary row
> I want to update the users primary address to the rest of the users where it's different.
I need to query the description of the Sales.SalesOrderHeader.Status column from the AdventureWorks OLTP, which looks like this:
| SalesOrderID | RevisionNumber | OrderDate | ShipDate | Status |
+--------------+----------------+------------+------------+--------+
| 43659 | 8 ...
There are two different limits that could be hit... and it's easy to tell which one (the error number and message) but it's too internal for a full post (nor does my 30 minutes of looking into it mean I'm the expert on it)
So I think I'll leave the answer somewhat... bland? You can edit it if you don't think it's good enough.
We could make it community too, not sure what all that does
@McNets xubuntu, kubuntu, lubuntu, and ubuntu are different only in their graphical environment - in this case it also means a different set of utility programs. lubuntu is the lightest, so I guess it's the best fit for you.
> Scientific Linux is a recompiled Red Hat Enterprise Linux, co-developed by Fermi National Accelerator Laboratory and the European Organization for Nuclear Research (CERN). Although it aims to be fully compatible with Red Hat Enterprise Linux, it also provides additional packages not found in the upstream product; the most notable among these are various file systems, including Cluster Suite and Global File System (GFS), ...
> ...FUSE, OpenAFS, Squashfs and Unionfs, wireless networking support with Intel wireless firmware, MadWiFi and NDISwrapper, Sun Java and Java Development Kit (JDK), the lightweight IceWM window manager, R - a language and environment for statistical computing, and the Alpine email client.