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
A boot moves into a snowshoe binding while a separate pouch stays behind

Moving a Table to Another Filegroup by Rebuilding Its Clustered Index

April 21, 2014
Pinal Dave
SQL Tips and Tricks
Clustered Index, SQL Data Storage, SQL Index

One statement moves the rows, but large-object data and other indexes stay behind. A small demo shows exactly where everything ends up.

Read More
Small interlocking wooden blocks form a practice structure beside loose pieces on a desk.

Building a SQL Server Home Lab That Costs Nothing

April 20, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Build a SQL Server home lab with free Developer software, sample data, and a repeatable backup and restore routine on your Windows computer.

Read More
Sealed glass jars of preserved peaches on a stone cellar shelf, with one jar opener hanging on a nail beside them.

Backing Up to Azure Blob Storage

April 19, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Backup and Restore, SQL Server

Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.

Read More
An extended adjustable crutch stands beside a shorter adjusted crutch with intact supports

Sizing nvarchar Columns: How Long Should a Name Be?

April 19, 2014
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL String, Unicode

A name fits the web form but fails in the table. Measure real lengths in characters and bytes before you choose a size.

Read More
A fishing float bobbing on a misty pond at dawn, ripples spreading, a rod propped on the bank beside a net.

Watching Live Data With the XEvent Profiler

April 18, 2014
Pinal Dave
SQL Performance
SQL Extended Events, SQL Profiler, SQL Server, SQL Server Management Studio

XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.

Read More
SQL SERVER - Tools for Proactive DBAs - Central Management Server - Notes from the Field #024

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #024

April 17, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SQL Scripts

Tools for proactive DBAs: after many AlwaysOn Availability Group projects, John Sterrett hears the same two questions and answers both in this Notes from the Field episode.

Read More
Golfers seen from afar: one swinging on the tee, one waiting next, one searching the long grass for a ball

Running, Runnable, Suspended: The Life of a Query in sys.dm_exec_requests

April 17, 2014
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Server, SQL Wait Stats

Read running, runnable, and suspended SQL Server requests, inspect task states, and compare scheduler queues before diagnosing CPU pressure.

Read More
A potato ricer above regular portions and a smaller final remainder

Loan Amortization Schedules With a Recursive CTE

April 16, 2014
Pinal Dave
SQL Tips and Tricks
CTE, Mathematics, SQL Datatype

Why does the last loan payment leave a few cents behind? A recursive CTE, a rounding rule and a final reconciliation fix it.

Read More
A partly filled punching bag with spare filling beside its roomy outer cover

Target Server Memory vs Total: Is SQL Server Still Growing

April 15, 2014
Pinal Dave
SQL Tips and Tricks
SQL Counter, SQL Memory, SQL Server Configuration

A big gap between target and total memory is often just room to grow. Here is how to check it before you call a server starved.

Read More
SQL SERVER - Finding Last Backup Time for All Database – Last Full, Differential and Log Backup - Optimized

SQL SERVER – Finding Last Backup Time for All Database – Last Full, Differential and Log Backup – Optimized

April 14, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL DMV

An optimized script from SQL expert TheSQLGuru that shows the last backup time for all databases, covering the last full, differential and log backup.

Read More
Previous 1 … 305 306 307 308 309 310 311 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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