10+ tips for working smarter with SQL

The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started

Inequality!

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.

view, index and schemabinding!

CRUD generator

Script to generate create, read, update, and delete scripts for a table.

decimal

The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL2005 ReportOnly Ver

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2000 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.

The Automated DBA: Batch Database File Grower - SQL 2005 Version

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.