June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL Index, SQL PASS, SQL User Group
Microsoft Community Tech Days are here! Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Community Tech Days are coming to Ahmedabad on Oct 3, 2009. I will be presenting the session ‘SQL Server 2008 – The Other Side…
Read More

SQLAuthority News – Download IIS Database Manager

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL Utility
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides…
Read More

SQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator.

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Error Messages
Recently, while I was scheduling a live meeting for one of my online training sessions, I kept receiving the following error message repeatedly. I had never encountered this type of error before, and despite searching online for a long time, I could not solve this problem. After several failed attempts,…
Read More

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL White Papers
Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…
Read More