by Malaika Kumar | Mar 18, 2024 | SQL Server
Introduction Regular maintenance is a cornerstone of SQL Server database management, ensuring optimal performance, reliability, and the longevity of database systems. In today’s fast-paced IT environments, especially with the growing adoption of cloud and...
by Adam Fulton | Sep 26, 2021 | SQL Server
Find Missing Indexes before going into production Find missing indexes the right way! First of all, finding a missing index is not a rocket science. Always find and create missing indexes before you deploy the code to the production environment. DBA’s and...
by Adam Fulton | Sep 17, 2021 | SQL Server
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',...