Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided
Read More...
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the
Read More...