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
Envelopes dropping through a letter slot into a large basket

Designing Tables for High Insert Rates

September 17, 2007
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Server, Table Partitioning, Transaction Log

High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.

Read More
Click to include actual execution plan.

SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan

August 28, 2007
Pinal Dave
SQL Performance
DBA, Execution Plan, SQL Scripts

Actual Execution Plan or Estimated Execution Plan? I always use the actual plan because it is accurate. Shortcuts: CTRL+M for actual, CTRL+L for estimated.

Read More
SQL SERVER - 2005 - Explanation and Script for Online Index Operations - Create, Rebuild, Drop

SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop

August 17, 2007
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server DBCC

What are online index operations? SQL Server 2005 Enterprise Edition can create, rebuild and drop indexes without locking tables, and I explain how.

Read More
SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE

August 15, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL Stored Procedure

How to copy data from one table to another without a cursor: INSERT INTO SELECT for an existing table, or SELECT INTO to create a new table.

Read More
SQLAuthority News - Author Visit - Database Architecture and Implementation Discussion - New York, New Jersey Details

SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details

August 13, 2007
Pinal Dave
SQL Performance
DBA, SQL Backup and Restore, SQL Index, SQLAuthority Author Visit

Notes from my database architecture meeting in New York and New Jersey: backup routines, index optimization and the maintenance tasks we discussed.

Read More
A harbor crane lifting a cargo net full of sacks onto a boat, with one sack waiting alone on the quay

Fast Bulk Inserts From Python

August 3, 2007
Pinal Dave
SQL Performance
Batch, Python, SQL Performance, SQL Server

Bulk inserts from Python work best with parameterized executemany, measured batch sizes, a tested fast_executemany path, and clear restart rules.

Read More
A garden of perfectly clipped square hedges, while one overgrown apple tree in the corner stands unpruned.

Index Maintenance on Modern Storage

July 31, 2007
Pinal Dave
SQL Performance
DBA, Maintenance Plan, SQL Data Storage, SQL Index, SQL Statistics

Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.

Read More
Previous 1 … 117 118 119 120 121 122 123 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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