On day-to-day basis a DBA might come across with the issues on the fragmentation on the database, it may not be possible to design the database that will be totally efficient and optimum to perform without any issues. Due to the fact of data inserts,
Read More...
In SQL Server 2005 Dynamic Management Views (DMV) & DM Functions (DMF) allows you the look inside the server to return the required information. It will also helps you to monitor the server instance health and performance to diagnose the problem.
Read More...
How to know whether my indexes are being used or not? This is most interesting question I have come across through the forums since the SQL 2000 version usage days, you may not have easy way to find out using SQL Server 2000 or even you have to run a
Read More...