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
Sep1

Designing Your First Table: Columns, Keys and Data Types

Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Column, SQL Constraint and Keys, SQL Datatype, SQL Table Operation
1 Comment

Designing Your First Table gets easier when you decide what it must hold before you write any SQL. This post walks through naming, data types, NULL or NOT NULL, a primary key, a default and a check constraint on a small Customers table. It also shows what to leave for later.

Continue Reading
Aug31

Table-Valued Parameters: Sending Thousands of Rows in One Call

Pinal Dave
SQL Tips and Tricks
DotNet, SQL Scripts, SQL Server, SQL Stored Procedure
No Comments

Send thousands of rows in one call with table-valued parameters, compare round trips, and handle missing column statistics accurately.

Continue Reading
Aug30

Read-Only Filegroups: Locking Away Old Data

Pinal Dave
SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts
1 Comment

Read-only filegroups let you lock old data so nothing can change it by accident. This post moves old rows to their own filegroup, makes it read-only, shows what still works and what fails, and explains how partial backups skip the locked data.

Continue Reading
Aug29

Pages and Extents: How SQL Server Stores Rows in a Data File

Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Datatype, SQL DMV
1 Comment

Pages and Extents are the building blocks of every SQL Server data file. A page is 8 KB, an extent is eight pages, and a row has to fit on a page. This post shows how to count the pages a table uses and what happens when a row is too wide.

Continue Reading
Aug28

SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan

Pinal Dave
SQL Performance
6 Comments

An overloaded ERP system taught me a lot. Here are my tips for SQL query optimization by analyzing the query plan of the most resource consuming queries.

Continue Reading
Aug28

Database Roles: Give Permissions to Groups, Not People

Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server Security
1 Comment

Database roles let you grant permissions to a group once, then add and remove members as jobs change. This post covers the fixed roles and the risk of db_owner, shows how to create a custom role, and checks role membership and permissions with queries.

Continue Reading
Aug27

Standard Developer vs Enterprise Developer Edition in SQL Server 2025

Pinal Dave
SQL Tips and Tricks
DBA, SQL Licensing, SQL Server, SQL Server Installation
No Comments

Choose Standard Developer or Enterprise Developer in SQL Server 2025, inspect the edition, and test against production features.

Continue Reading
Previous 1 … 471 472 473 474 475 476 477 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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