Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.
Read More »Tag Archives: Mehmet Deveci
SQL Server Change Database Name
Hi, Especially during the creation of Test environment, you may need changing database name as SQL Server DBA.
Read More »SQL Server Change Recovery Model
Hi, You may need to change database recovery model of SQL Server.
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 one is blocked.
Read More »SQL Server Index Usage Stats
Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.
Read More »SQL Server Rebuild Index Query
Hi All Indexes in the SQL Server database will be fragmented After related tables got many update, delete transactions.
Read More »SQL Server Performance TOP IO Query -1
Hi, If you got slowness complaint from customer, you need to monitor SQL Server Instance and database which sql is consuming a lots of resource.
Read More »