June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 64 bit Architecture and White Paper

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Coding Standards, SQL Download, SQL Server Security
In supportability, manageability, scalability, performance, interoperability, and business intelligence, SQL Server 2005 provides far richer 64-bit support than its predecessor. This paper describes these enhancements. Read the original paper here. Following abstract is taken from the same paper. Another interesting article on 64-bit Computing with SQL Server 2005 is here.…
Read More

SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Software Development, SQL Download
Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data from Microsoft Windows and SQL…
Read More

SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON

Pinal Dave
SQL
SQL Download, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

This error occurs when the user has attempted to insert a row containing a specific identity value into a table that contains an identity column. Run following commands according to your SQL Statement. Let us learn about the IDENTITY_INSERT.

Read More