t sql – Reclaiming space after delete statement in SQL Server

I have some tables used in reporting and some of them grow huge with the daily ETL so I have implemented som jobs that delete rows more that x days old. E.g. everyday 10% new data gets added and I delete 10% of the oldest rows in another job.

Do I need to do something for efficiency? Some tables are heaps with nonclustered indexes and some also have clustered indexes. E.g. to I need to rebuild the tables in case of heaps or rebuild index in case of clustered index on the table? If so how often? Most tables are only used once per day and when all joins and calculations are done they get extracted for visualization in a non-live manner.

I know a little about index fragmentation and that one can query fragmentation in percent. How much do I need to worry about the above scenario?

postgresql – Disk space efficient foreign key index for insert intensive scientific database?

I’m working tuning a scientific database whose associated simulation is very insert intensive (i.e., run for a long time inserting data, execute summary query at the end). One of the tables is starting to cause some problems since the table size is 235 GB with index sizes of 261 GB, and the server only has 800 GB so we would like to free up a bit of space.

Currently there is one foreign key reference (integer data) that is stored as a clustered b-true. This has been good for the summary queries, but likely isn’t helping the disk space issues.

Is there a more disk efficient way of storing this foreign key index? Would it make sense to switch over to a hash index instead of the b-tree index?

Space to Switch to Hand Tool in Tile Palette?

Hi I just download a Utility called: Hold Spacebar for Hand (drag) Tool

I read the code and I can understand it, but now I wondering how can I modify this to support the same functionality but works in Tile Palette tab, thanks!

enter image description here

JuneDataplace.Com – SSD Space, cPanel, MariaDB, AutoSSL & more Starting $2.25/m ( 50% OFF For Life) | NewProxyLists

It doesn’t matter if you’re an enterprise level business, a small business or even someone who needs a server or web hosting for personal use, we have a suitable package for you. Our array of high performance services in Dedicated Servers. JuneDataplace reputation will be going to be built on trust, friendliness and top-level support for all clients throughout the world. Combine that with 24/7 technical support and a 99.99% uptime guarantee, you are in safe hands with us. We take pride in our first class support and are always happy to assist our customers.

Payment Methods
We currently accept PayPal & Bank Transfer.

Also as a promotion, we have a 50% recurring discount using coupon code ’50OFF’.

Shared Web Hosting Plans
(Efficient. Reliable. Affordable)

Starter Plan For $4.50/m

  • 10 GB SSD Disk Space
  • Unlimited Data Transfer
  • Unlimited Hosted Domains
  • Unlimited Email Accounts
  • Includes Cloudflare CDN
  • High Performance Servers
  • Includes Cloudflare CDN
  • MariaDB Database Support
  • Cloudlinux Operating System
  • One-Click Auto Installer (Softaculous)
  • cPanel Control Panel
  • Programming Support (PHP 5.4x-7.0x, Perl, Python, RoR, GD, cURL, CGI, mcrypt, ioncube, Apache 2.4x, Ruby On Rails, Etc)
  • 99.999% Uptime Guaranteed

Order Now

Basic Plan For $6.50/m

  • 25 GB SSD Disk Space
  • Unlimited Data Transfer
  • Unlimited Hosted Domains
  • Unlimited Email Accounts
  • Includes Cloudflare CDN
  • High Performance Servers
  • Includes Cloudflare CDN
  • MariaDB Database Support
  • Cloudlinux Operating System
  • One-Click Auto Installer (Softaculous)
  • cPanel Control Panel
  • Programming Support (PHP 5.4x-7.0x, Perl, Python, RoR, GD, cURL, CGI, mcrypt, ioncube, Apache 2.4x, Ruby On Rails, Etc)
  • 99.999% Uptime Guaranteed

Order Now

Advance Plan For $15.50/m

  • 50 GB SSD Disk Space
  • Unlimited Data Transfer
  • Unlimited Hosted Domains
  • Unlimited Email Accounts
  • Includes Cloudflare CDN
  • High Performance Servers
  • Includes Cloudflare CDN
  • MariaDB Database Support
  • Cloudlinux Operating System
  • One-Click Auto Installer (Softaculous)
  • cPanel Control Panel
  • Programming Support (PHP 5.4x-7.0x, Perl, Python, RoR, GD, cURL, CGI, mcrypt, ioncube, Apache 2.4x, Ruby On Rails, Etc)
  • 99.999% Uptime Guaranteed

Order Now

*If you require something that boasts a little more power request a quote today!.*

Contact Us
If you have any questions about our services or would like to request a custom package please send us a Ticket or email us at sales@junedataplace.com
We also have a live chat link on the side of our website.

Mac mission control add new space + icon is on left – not the right

How can I fix this?

enter image description here

I don’t recall changing a setting for this, but I really wish it was on the right as per normal (was like this prior to Big Sur update as well.)

Normal is right I assume – much better!

https://support.apple.com/en-au/HT204100

dnd 5e – Can a space from Phantasmal Force move?

Your DM’s ruling seems correct.

The real “affected area” of phantasmal force is the mind of the target:

You craft an illusion that takes root in the mind of a creature that you can see within range.

Notably, there is no requirement that the target be in or adjacent to the illusion you create. Once the target fails the save, they are affected by the spell until they pass the check or the spell ends. The creature can end the spell in this way:

The target can use its action to examine the phantasm with an Intelligence (Investigation) check against your spell save DC. If the check succeeds, the target realizes that the phantasm is an illusion, and the spell ends.

Otherwise, they are affected until the 1 minute duration is up or your concentration ends. You can run away all you want, but your the illusion is rooted in your mind until you use your action to investigate the illusion and pass the check, or the caster ends the spell by dropping concentration/running out the time.

So your DM’s ruling is correct, and seems like a pretty brilliant way to narrate the effects of the spell. Maybe they diverged from the prescribed “size” of the illusion, but the mechanical effects on your characters mind seem right on.

complexity theory – Configuration of a space bounded turing machine

A configuration of a turing machine is defined as the following:

an ordered triple (x, q, k) ∈ Σ∗ × K × N, where x denotes the string
on the tape, q denotes the machine’s current state, and k denotes the
position of the machine on the tape

I have read in a paper that a space bounded non-deterministic turing machine (NSPACE), has at most 2^(d*n) configurations on an input of length n, where d is a constant, how do we know that this is true? what is d? and how can we prove it?

upgrade – Drop tables but space not claimed in postgres 12

I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option.

So basically I am having two data directories i.e. One is old data directory (v9.5) and the current one in running state (v12.4).

Yesterday I have dropped two tables of size 700MB and 300MB.

After connecting to postgres using psql utility I can see database size whose tables was dropped got decreased (with l+ ) but what is making me worry is that only a few MBs have been freed from storage partition.

I have checked if any deleted open file is there on OS level using lsof but there is none. I have run vacuumdb only on that database but no luck

Looking for the solution.

ripple – Disk Space of Rippled testnet server

I am planning to create rippled testnet server.
According to below site, I need 360 GB Disk Space for 750,000 Ledger versions.
I believe the estimate is for mainnet, but is it same for testnet?
https://xrpl.org/capacity-planning.html

When I run rippled locally on testnet, it seems like ledger size of testnet is less than that of mainnet.
However, I couldn’t find any specification regarding disk space or ledger size of testnet.

optics – Aperture iris in front of lenses (in object space)

I am looking for such lenses as well.
In general putting the aperture at the front or outside is avoided because not good; best is to put the aperture more or less in the center of the objective. With the aperture in front you’ll have more aberrations and/or need bigger and more expensive design.
Only in two cases the front aperture design is used:

  1. if the lens is very small and simple, like, really just one group (see the Kodak vest camera and the Triplet), here you cannot put the aperture in the middle! Choose, in the front or in the back.
  2. Otherwise, you put the aperture in front only if you are absolutely forced to do that, typically for coupling with other optical systems.

Small & simple:
Mobile phone lenses; to make them so compact, the aperture is usually placed at the brim of the front lens. Not really outside, but on the brim.

Forced:
Pinholes and many probe objectives, that need to peep from an hole; the hole is the natural aperture and the lens must be built to use all the light that goes through such hole; putting another aperture will cause vignetting. Nice example the SO spy lenses by Zeiss Jena:
Marco Cavina or see the catalog of Marshall Electronics.

Non-photographic lenses:

  • Laser scanning lenses, called F-theta Rogonar; the laser light is coming form the aperture position.
  • All eyepieces: the aperture is well outside, at the “exit pupil”, so I can place my eye with my iris in this place.

If you are curious about aberrations etc, the best short introduction I’ve found are those slides from Jena:
Gross Jena 2017; lecture 11/3, stop position.