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
SQL SERVER - Primary Key Constraints and Unique Key Constraints

SQL SERVER – Primary Key Constraints and Unique Key Constraints

February 5, 2007
Pinal Dave
SQL Performance
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.

Read More
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.

Read More
A barrel marked LOG overflowing with paper, and a person hesitating at the tap.

SQL SERVER – Shrinking Truncate Log File – Log Full

December 30, 2006
Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Scripts, Transaction Log

The old code I used to truncate log file space with DBCC SHRINKFILE and BACKUP LOG WITH TRUNCATE_ONLY. It breaks the log chain, so take a full backup after.

Read More
Previous 1 … 125 126 127 128
  • Books
  • Testimonials
  • Privacy Policy

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