We get many requests to help with performance issues. we strongly recommend users to sign up: SELECT sqlschema.name AS 'SchemaName', object_name(sqlfrag.object_id) AS 'TableName', sqlindexes.name AS 'IndexName', sqlfrag.alloc_unit_type_desc AS 'AllocUnitType',...

Ever wondered why SQL Server takes long time to perform below operations? Create a database Expand data files for additional growth Automatic data file growth due to auto-grow settings Restoring a database, etc. Today we will be looking into a powerful and yet not...