sql server select machine name

SQL Server DBA Scripts All in One – Useful MS-SQL ( DBA ) Database Administration Scripts

Hi, I will share SQL Server DBA Scripts in this post.

Hi, Database objects stats should be up to date for making the right decision of SQL Server optimizer.

Hi All Indexes in the SQL Server database will be fragmented After related tables got many update, delete transactions.

Hi, You should find that which of wait events are in the SQL Server database.

Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.

Hi, You should find that which of wait events are in the SQL Server database and status of currently waiting tasks.

Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.

Hi, The use of Index in the SQL Server database occurs in environments that require the most performance, speed, and memory savings.

Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.

Hi, TempDB is one of the most important system databases of SQL Server.