float

In the Ultra Transcenders books

DBX-DEP

Each book explains float in context, with comparison tables and the common traps.

Terms in this definition

• float

  An approximate numeric type based on IEEE 754. It isn't a good fit for money, rounding or testing equality; decimal is the exact type to use in those cases.

• CONVERT

  Works much like CAST, changing a value's data type in T-SQL, with the addition of an optional style number; 126, for instance, gives ISO 8601 dates.

• DECIMAL

  Use DECIMAL(p,s) for money or any figure where floating-point rounding would be wrong. Precision p can be 1 to 38 and is 10 if left out; scale s is 0 if left out.

• Materialized view

  A view that stores its query output ahead of time. A serverless pipeline maintains it, refreshing it on demand with REFRESH MATERIALIZED VIEW, on a schedule or when upstream data changes, incrementally when it can.

Related terms

• block reuse

  Merges and synthetic fulls on object storage link to blocks the bucket already holds rather than uploading them afresh, so real consumption can come in under the logical size. Disk repositories get a similar saving from Fast Clone.

• Budget

  A spending threshold you set in Cost Management for a management group, subscription or resource group. Alerts go out as real or forecast costs approach it, yet hitting the figure never halts any resource; wiring it to an action group lets automation react.

• CD-ROM

  A drive for optical discs, either real or virtual. NGT installation requires a VM to have a vacant one on IDE or SATA, and Foundation imaging wants it listed first for BIOS booting.

• Cluster rebuild preference

  Decides how rebuilds behave during planned maintenance. Smart is the default from AOS 6.8 and separates maintenance from real failures so fewer rebuilds run needlessly; the other option is Immediate, and the deprecated Delayed becomes Smart.

• Custom detection

  Microsoft now suggests these Defender XDR rules when creating new detections for Sentinel or Defender XDR. Each is built on an advanced hunting query, runs periodically or in near real time (NRT), raises alerts and may take response actions.

• Custom voice

  Text to speech feature with limited access that produces a distinctive synthetic voice, for a brand or character, trained on recordings of a real speaker.

• Dark launching

  Putting features into production unseen, or for a limited cohort, usually behind flags, to study telemetry. A canary differs: it checks back-end behaviour under real traffic.

• Date validator

  A validator that a custom sensitive information type's regex can use to make sure a date within the matched text is a real date in the selected format.