IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: sql server optimizer

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

Mehmet Salih Deveci May 30, 2019 SQL Server DBA Scripts 16

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

SQL Server Update Database Statistic

Mehmet Salih Deveci March 12, 2019 SQL Server 0

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

SQL Server Wait Events -3

Mehmet Salih Deveci March 11, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 1

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

SQL Server Wait Events -2

Mehmet Salih Deveci March 11, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 0

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

SQL Server Change Database Name

Mehmet Salih Deveci March 8, 2019 SQL Server 0

Hi, Especially during the creation of Test environment, you may need changing database name as SQL Server DBA.

SQL Server Change Recovery Model

Mehmet Salih Deveci March 8, 2019 SQL Server 0

Hi, You may need to change database recovery model of SQL Server.

SQL Server Change TempDB File Location

Mehmet Salih Deveci March 7, 2019 SQL Server 1

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

SQL Server Wait Events -1

Mehmet Salih Deveci March 7, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 1

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

SQL Server Database Objects Statistics

Mehmet Salih Deveci March 7, 2019 SQL Scripts, SQL Server, SQL Server DBA Scripts 5

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