Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Index, SQL Scripts
My present article covers two fundamental questions. 1) What is the maximum number of columns included in Primary Key Index/Constraint? 2) What is fix/solution for the following error: Msg 1904, Level 16, State 1, Line 1 The index ” on table ‘dbo.Table_2’ has 17 column names in index key list.…
Read More

SQL SERVER – Mirrored Backup and Restore and Split File Backup

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts
Introduction This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore. Conventional Backup and Restore Spilt File Backup and Restore Mirror…
Read More

SQL SERVER – Automated Index Defragmentation Script

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Index, SQL Scripts
Index Defragmentation is one of the key processes to significantly improve performance of any database. Index fragments occur when any transaction takes place in database table.  Fragmentation typically happens owing to insert, update and delete transactions. Having said that, fragmented data can produce unnecessary reads thereby reducing performance of heavy…
Read More
All Articles MarchUG6

SQLAuthority News – Launch of Gandhinagar SQL Server User Group

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DigiCorp, MVP, SQL User Group, SQLAuthority Author Visit
Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. This launch event, unexpectedly, saw over 50 database enthusiasts participating. It was really a moment of pleasant surprise when we ran out of chairs. The otherwise…
Read More
All Articles backup4-500x400

SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Backup and Restore, SQL Data Storage, SQL Utility
It goes without saying that Database Backup is the most important task for any Database Administrator (DBA). Naturally, large organizations always have a team of DBAs who execute Database Backup tasks. No matter how big or small an organization is, the importance of database backup remains the same across the…
Read More

SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Identity, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table
Some time ago I was helping one of my Junior Developers who presented me with an interesting situation. He had a table with Identity Column. Because of some reasons he was compelled to delete few rows from the table. On inserting new rows in the table he noticed that the…
Read More