Paul Mu

  • Interests: Travelling, Movies and Learning a Foreign Language

SQLServerCentral Article

Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.

2.5 (2)

You rated this post out of 5. Change rating

2006-11-16

15,591 reads

SQLServerCentral Article

A Guide to Application Memory Tuning

Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.

You rated this post out of 5. Change rating

2006-10-16

9,012 reads

Blogs

A Conversation That Refused to End: What We Learned from Our First Event in Zurich

By

On May 8, 2025, we hosted our first official event in Switzerland at Prime...

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

Read the latest Blogs

Forums

Are Data Breaches Inevitable?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are Data Breaches Inevitable?

The Internals of Writing a Page

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Internals of Writing a...

How to Safely Remove a SQL Server Data File Without Downtime

By shukla.chandan12

Comments posted to this topic are about the item How to Safely Remove a...

Visit the forum

Question of the Day

The Internals of Writing a Page

In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?

See possible answers