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.

Blogs

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Giving a Security Webinar this Wednesday

By

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Read the latest Blogs

Forums

sp_dropserver - Bug/behavior change - Leaves transaction open after TRY...CATCH

By Ronzo

Verified on latest CU 10 for SQL 2022. Confirmed works correctly on SQL 2019...

broker error

By joey

Hello, I install a broker under sql server 2016 and I have a message...

Suggestion on HA DR solution for transactional replication published database

By Saran

Hi All, I am planning for HA DR solution for transactional replication published database....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers