sp_create_plan_guide introduced with sql server 2005. With this sp, you can increase the performance of your queries that you can’t intervene or change, by adding …
Read More »
sp_create_plan_guide introduced with sql server 2005. With this sp, you can increase the performance of your queries that you can’t intervene or change, by adding …
Read More »While current transaction waiting for a lock in a session, the following error will occur in the database when the corresponding session terminated unexpectedly with …
Read More »Indexes can be disabled in SQL Server 2005 and later versions. If the index is disabled, it is necessary to rebuild the index to enable …
Read More »When a user tries to create a materialized view in a different schema, if the user of that schema does not have create table authority, …
Read More »It is possible to attach the database without a log file using ATTACH_REBUILD_LOG. With the help of the following script, we attach the ASPNETDB database …
Read More »The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations and security policies to help eliminate security risks and improve database security. Using the DBSAT …
Read More »First of all, this is an old technology. Many of people use 64 bit operating systems. So there is no need to configure awe. But …
Read More »We use the incremental backup of the primary database to fix the gap that occurs in the standby databases. If the managed recovery is turned …
Read More »kfed and kfod are under $ORACLE_HOME/bin. With these tools, we can learn about asm disks and edit the information in the disk headers. When using …
Read More »CLR is a feature introduced with SQL Server 2005. Using the CLR (Common Language Runtime), you can perform a number of complex processes that you …
Read More »