Remove 2000 Remove Cache Remove Storage
article thumbnail

When Do SQL Server Sorts Rewind?

SQL Performance

Its raison d’être is to cache result rows from a plan subtree, then replay those rows on subsequent iterations if any correlated loop parameters are unchanged. Table-valued functions use a table variable, which can be used to cache and replay results in suitable circumstances. Spools are the least costly way to cache partial results.

Servers 106
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. Stable Media Stable media is often confused with physical storage.

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

Note: You may need to execute the dbcc a second time so buffer cache is hot, eliminating I/O sub-system variants. 32GB RAM, 4 Core Hyper-threaded enabled 2.8Ghz, SSD Storage. iID int NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED, strData nvarchar(2000) NOT NULL. ). or newer release. Actual Scenarios. SQL Server. SQL Server 2014.

article thumbnail

Progress Delayed Is Progress Denied

Alex Russell

Chrome has missed several APIs for 3+ years: Storage Access API. An extension to Service Workers that enables browsers to present users with cached content when offline. A-series chips have run circles around other ARM parts for more than half a decade, largely through gobsmacking amounts of L2/L3 cache per core. CSS color().

Media 145
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Description.

Servers 90
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document. and ​​ 2000. DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk.

Servers 40
article thumbnail

A Guide To Optimizing Images For Mobile

Smashing Magazine

Well, that depends on the width of your site, but I think somewhere between 1200 and 2000 px should be your max. Instead, you can integrate your existing image server (on your web host) or external storage service (like S3) with ImageKit. There was no need to move their images to ImageKit or another third-party storage service.

Mobile 73