Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
Is there a way in SQL Server to get a report of index usage? i know starting with SQL Server 2005, you can get reports of top resource-using queries, based on what's in the Plan Cache: i'm curious ...
If I have an infrastructure with some Web Servers (Windows 2003 and IIS) and a Database (SQL Server 2005) and ASP.net, I wonder if there is a catch-all tool that simply allows me to say "Ok, I now ...