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 new wooden shelf unit standing on a workshop floor beside a small dish of wooden pegs, one red peg nearby.

Designing Your First Table: Columns, Keys and Data Types

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

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.

Read More
A donkey with full panniers and a red blanket walking a mountain path.

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

August 31, 2013
Pinal Dave
SQL Tips and Tricks
DotNet, SQL Scripts, SQL Server, SQL Stored Procedure

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

Read More
A glass display case in a quiet gallery holding three old ceramic jars on a red base.

Read-Only Filegroups: Locking Away Old Data

August 30, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Scripts

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.

Read More
Eight identical plain boxes packed in a shallow wooden tray in two rows of four, one box red.

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

August 29, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Datatype, SQL DMV

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.

Read More
Compare profiling properties.

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

August 28, 2013
Pinal Dave
SQL Performance

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.

Read More
A row of wooden coat hooks on a wall, each holding a ring of keys, a few rings with small red tags.

Database Roles: Give Permissions to Groups, Not People

August 28, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server Security

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.

Read More
A practice football goal on a training pitch matching the stadium goal behind it, a red corner flag between

Standard Developer vs Enterprise Developer Edition in SQL Server 2025

August 27, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SQL Licensing, SQL Server, SQL Server Installation

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

Read More
An open book on a pale table with a pressed leaf resting across its pages.

Script Table As in SSMS: CREATE, INSERT and SELECT in One Click

August 27, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Table Operation, Starting SQL

Script Table As is the right-click menu in SSMS that writes CREATE, SELECT, INSERT, UPDATE and DELETE statements for a table. This post shows what each option writes, what the scripts leave out, and how to run them safely.

Read More
Three tall windows with pale blinds set at different angles, sunlight falling in strips across the floor.

Query Options in SSMS: Settings That Change Your Results

August 26, 2013
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Scripts, SQL Server Configuration, SQL Server Management Studio

Query Options are the per-window settings in SSMS that change how a query runs and how its results look. This post covers results to grid, text or file, the character limits that cut long values, the SET options that change answers, and why SSMS and your application can disagree.

Read More
A row of wall switches on wooden plates, the middle switch red and the others muted gray and cream.

Commenting Out Code: Testing Safely in SSMS

August 25, 2013
Pinal Dave
SQL Tips and Tricks
SQL Delete, SQL Scripts, SQL Server Management Studio, SQL Shortcut

Commenting Out Code is the quickest way to switch off part of a script while you test the rest. This post covers the SSMS shortcuts, testing one WHERE filter at a time, the trap of GO inside a block comment, and a safety note to leave above a DELETE.

Read More
Previous 1 … 329 330 331 332 333 334 335 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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