SQL Server Architecture

Technical Article

Query processing architecture guide

  • Article

The SQL Server Database Engine processes queries on various data storage architectures such as local tables, partitioned tables, and tables distributed across multiple servers. The following sections cover how SQL Server processes queries and optimizes query reuse through execution plan caching.

You rated this post out of 5. Change rating

2023-10-20

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

  • Article

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.

(5)

You rated this post out of 5. Change rating

2022-02-18

7,271 reads

Blogs

Monday Monitor Tips: The MCP Server

By

I have been experimenting with MCP servers in a few ways, and pressing on...

Programmatic Tool Calling with the Claude SDK

By

Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...

A New Word: Mauerbauertraurigkeit

By

mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...

Read the latest Blogs

Forums

Advanced T-SQL: Replacing Slow Cursors with Window Functions

By sabyda

Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...

Finding Bad Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Bad Queries

The Service Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Service Name

Visit the forum

Question of the Day

The Service Name

What does @@servicename return?

See possible answers