This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
One very tall shelf beside a long row of short shelves in a warehouse

Horizontal and Vertical Scaling for Databases

October 8, 2013
Pinal Dave
SQL Tips and Tricks
Database, Hardware, SQL High Availability, SQL Server

Horizontal and vertical scaling solve different SQL Server capacity problems; compare larger machines, additional nodes, and the costs each brings.

Read More
An overflowing toy box beside a larger empty toy chest and a few small crates in a child's room.

Scale Up or Scale Out: Signs Your Server Needs More Hardware

April 22, 2013
Pinal Dave
SQL Performance
DBA, Hardware, SQL CPU, SQL Memory, SQL Wait Stats

Decide when to scale up SQL Server by checking sustained CPU demand, memory pressure, storage latency, and whether query tuning comes first.

Read More
A wide new road ending at an old one-lane stone bridge, cars queued at the bridge and the road behind empty.

Choosing Hardware for SQL Server Now

April 12, 2013
Pinal Dave
SQL Tips and Tricks
Disk, Hardware, SQL CPU, SQL Server

Choosing hardware for SQL Server Now means matching core cost, memory, and storage latency to measured workload needs and future growth.

Read More
A moving van at the open door of a new house at dusk, one last box on the ramp

Moving a Database to New Hardware With Little Downtime

April 28, 2012
Pinal Dave
SQL Tips and Tricks
DBA, Hardware, Log Shipping, SQL Backup and Restore, SQL Migration

Moving a database to new hardware with little downtime uses early restore, a maintained log chain, final synchronization, and a tested client switch.

Read More
A carpenter measuring an old doorway with a stretched string, fresh timber waiting uncut on trestles.

Sizing a New SQL Server

May 16, 2010
Pinal Dave
SQL Tips and Tricks
DBA, Hardware, SQL CPU, SQL Memory

Sizing a new SQL Server starts with workload evidence, growth, and recovery goals to estimate CPU, memory, storage, and headroom.

Read More
Two brass balance weights of different size on a laboratory balance

SQL SERVER – The Difference between Dual Core vs. Core 2 Duo

May 2, 2010
Pinal Dave
SQL Tips and Tricks
Hardware, SQL Server

Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com