SQL Server DBA Scripts All in One – Useful Database Administration Scripts

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

Read more

SQL Server Update Database Statistic

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

Read more

SQL Server Wait Events -3

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

Read more

SQL Server Wait Events -2

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

Read more

SQL Server Change TempDB File Location

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

Read more

SQL Server Wait Events -1

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

Read more

SQL Server Database Objects Statistics

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

Read more

SQL Server Active Sessions and Status

Hi, Most frequently task of DBA is monitor database and which session is active and which is inactive or which

Read more