Mac|Linux nano /etc/hosts
and paste this line at very bottom of file, save and exit
127.0.0.1 license.sublimehq.com
Fixed: flush/clear First, flush/clear DNS cache (e.g. sudo systemd-resolve --flush-caches for systemd-resolved). Second, restart your computer.
Windows c:\windows\system32\drivers\etc\hosts
| { | |
| "always_show_minimap_viewport": true, | |
| "bold_folder_labels": true, | |
| "color_scheme": "Packages/Material Theme/schemes/Material-Theme.tmTheme", | |
| "font_options": | |
| [ | |
| "gray_antialias", | |
| "subpixel_antialias" | |
| ], | |
| "font_size": 10, |
| let charType = () => { | |
| let group = [ 0, 0, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2 ] | |
| return group[parseInt(Math.random() * group.length)] | |
| } | |
| let charASCII = t => parseInt(Math.random() * (t === 0 ? 9 : 25)) | |
| const randomString = l => { | |
| l = l || 32 | |
| let result = '' | |
| for (let i = 0; i < l; i++) { |
| sysctl -w vm.max_map_count=262144 | |
| sudo chmod 700 /home/git/data/uploads | |
| sudo chmod -R ug+rwX,o-rwx /home/git/data/repositories/ | |
| sudo chmod -R ug-s /home/git/data/repositories/ | |
| sudo find /home/git/data/repositories/ -type d -print0 | sudo xargs -0 chmod g+s | |
| sudo -u git -H bundle exec rake gitlab:check RAILS_ENV=production |
| apt-get update -y && apt-get upgrade -y && apt-get dist-upgrade -y | |
| vi /etc/network/interfaces | |
| auto enp0s25 | |
| iface enp0s25 inet static | |
| address 192.168.1.2 | |
| gateway 192.168.1.1 | |
| netmask 255.255.255.0 | |
| dns-nameservers 8.8.8.8 8.8.4.4 |
| # /etc/fstab: static file system information. | |
| # | |
| # Use 'blkid' to print the universally unique identifier for a | |
| # device; this may be used with UUID= as a more robust way to name devices | |
| # that works even if disks are added and removed. See fstab(5). | |
| # | |
| # <file system> <mount point> <type> <options> <dump> <pass> | |
| /dev/mapper/PGM--SERVER--vg-root / ext4 errors=remount-ro 0 1 | |
| # /boot was on /dev/sda1 during installation | |
| UUID=ee608de4-87ae-4fd4-a483-482ff96aef17 /boot ext2 defaults 0 2 |
| SELECT TOP 50 | |
| SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, | |
| (( | |
| CASE qs.statement_end_offset | |
| WHEN -1 THEN DATALENGTH(qt.TEXT) | |
| ELSE qs.statement_end_offset | |
| END - qs.statement_start_offset)/2)+1), | |
| qs.execution_count, | |
| (qs.total_logical_reads + qs.total_logical_writes) / qs.execution_count as [Avg IO], | |
| qp.query_plan, |
Using UPDATE, DELETE or INSERT to move data can take quite a lot of time and use resources (IO) on both data and log files/disks. It is possible to avoid filling the transaction log with potentially lots of records while working on a big table: Using partition switching, only the metadata is changed.
There is no data movement involved and this is therefore performed really quickly (almost instantaneous).
###Sample table
The question does not show the original table DDL. The following DDL will be used as an example in this answer:
CREATE TABLE dbo.idT(
id int not null
Computer\HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System
npm install jquery bootstrap-sass bootstrap-loader css-loader node-sass resolve-url-loader sass-loader style-loader url-loader --save-dev
Note: I'm not sure if all dependencies are indeed necessary. I used dependencies from #215 and added others to get it working for Bootstrap 3.