Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Notes from the Field, Shrinking Database
[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…
Read More

SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Safepeak
Update: This blog post is written based on the SafePeak, which is available for free download. Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the…
Read More

SQL SERVER – Merge Two Columns into a Single Column

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Here is a question which I have received from user yesterday. Hi Pinal, I want to build queries in SQL server that merge two columns of the table If I have two columns like, Column1 | Column2 1                5 2                6 3                7 4                8 I want to output like, Column1…
Read More