SQL Index Archives - Page 64 of 64 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

SQL SERVER – Primary Key Constraints and Unique Key Constraints

February 5, 2007

Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Download, SQL Error Messages, SQL Index, SQL Joins, SQL Scripts, SQL Server Security

Primary Key and Unique Key both enforce uniqueness, but they differ in the index they create and in NULL handling. Here are the differences and the scripts.

A sunlit gouache workshop shows a localized repair within an otherwise orderly ceramic inlay panel.

SQL SERVER – ReIndexing Database Tables and Statistics with Targeted Maintenance

January 31, 2007

Pinal Dave

SQL Performance

Best Practices, SQL Constraint and Keys, SQL Cursor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Stored Procedure

ReIndexing Database tables starts with a measured maintenance need. I check the workload before choosing an index operation.