July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Latest Interesting Downloads and Articles

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL White Papers
White Paper: Precision Considerations for Analysis Services Users This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due…
Read More

SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility
This article is written by request and suggestion of Sr. Web Developer at my organization. Due to nature of this article most of the content are referred from Book On-Line. sqlwb command prompt utility which opens SQL Server Management Studio. sqlwb command does not run queries from command prompt. sqlcmd…
Read More

SQL SERVER – 2005 – Different Types of Cache Objects

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Cache, SQL Error Messages, SQL Server

About two months ago I reviewed book SQL Server 2005 Practical Troubleshooting: The Database Engine. Yesterday I received a request from reader, if I can write something from this book, which is not common knowledge in DBA community. I really like the idea, however I must respect the Authors copyright about this book. This book is unorthodox SQL book, it talks about things which can get you to fix your problem faster, if problem is discussed in book. There are few places it teaches behind the scene SQL stories.

Read More

SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling With RAISEERROR Function

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Scripts
One of the developer at my company thought that we can not use RAISEERROR function in new feature of SQL Server 2005 TRY…CATCH. When asked for explanation he suggested SQL SERVER – 2005 Explanation of TRY…CATCH and ERROR Handling article as excuse suggesting that I did not give example of…
Read More