June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Utility
I have received six emails in last four days asking for the resolution of error when tried to open newly installed SQL Server Book On-Line. Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9 1) Uninstall the versions of Book On-line (different languages, different releases etc) using…
Read More

SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Download, SQL Scripts, SQL Utility
Yesterday I posted small note about SQL SERVER – 2005 Best Practices Analyzer (July BPA). I received many request about how BPA is used. Some of readers has asked me to provide sample tutorial which can help start using BPA. This utility has many uses for best practice. I have…
Read More

SQL SERVER – 2005 Best Practices Analyzer (July BPA)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, SQL Download, SQL Utility
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. DOWNLOAD HERE Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More

SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL TempDB
#TempTable and @TempVariable are different things with different scope. Their purpose is different but highly overlapping. TempTables are originated for the storage and & storage & manipulation of temporal data. TempVariables are originated (SQL Server 2000 and onwards only) for returning date-sets from table-valued functions. Common properties of #TempTable and…
Read More

SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Cursor, SQL Download, SQL Scripts, SQL Stored Procedure
Common Properties of SP_EXECUTESQL and EXECUTE/EXEC The Transact-SQL statements in the sp_executesql or EXECUTE string are not compiled into an execution plan until sp_executesql or the EXECUTE statement are executed. The strings are not parsed or checked for errors until they are executed. The names referenced in the strings are…
Read More

SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL String
Error: Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000) When the the length is specified in declaring a VARCHAR variable or column, the maximum length allowed is still 8000. Fix/WorkAround/Solution: Use either…
Read More