Articles

SQLServerCentral Article

How Dynamic SQL Can Be Static SQL

This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server.

(2)

You rated this post out of 5. Change rating

2002-03-14

11,541 reads

Technical Article

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.

You rated this post out of 5. Change rating

2002-03-08

2,221 reads

Blogs

Narrow Task Decomposition in AI Pipeline Agents

By

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Car Update: August 2026

By

It’s been some time since I provided a car update, so I decided to...

Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To

By

An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...

Read the latest Blogs

Forums

Alamat BCA KCU Pantai Indah Kapuk Tlp:0817825533

By layanan_Bca88

Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...

Alamat Kantor BCA KCU Taman Duta Mas Tlp:0817825533

By m4rt1n4

Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...

Alamat Kantor BCA KCU Tanjung Priok Tlp:0817825533

By R4nt4u

Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...

Visit the forum

Question of the Day

Backing Up a DMK

In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?

See possible answers