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


15,570 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


8,978 reads


Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?


Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO


Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors


I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs


Delayed tcp acknowledgement registry setting

By Rasmus Remmer Bielidt

Our IT department contacted me recently and asked if they should change the default...

Fact Table - Various Grains

By flamblaster

Hi there, I'm on a team developing an enterprise data warehouse for our organization....

PostgreSQL Copy

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL Copy

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers