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,539 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.

2002-03-08

2,221 reads

Blogs

Building AgentDBA’s Slack Escalation

By

Until now, a CRITICAL finding did the right internal routing, but the last mile...

Changing the Owner Removes Permissions: #SQLNewBlogger

By

This is actually inspired by an article SQL Server Central, which taught me something...

T-SQL Tuesday #200 - I Bet It's Bad if I See...

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174

By m4rt1n4

Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...

ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174

By R4nt4u

Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers