What is a execution plan in SQL? Execution plan is a road map that determines how the query will work. Will the query use the …
Read More »How To Create Crontab Job On Linux
What is Crontab? If you want to perform regular operations(for example schedule a task) on Linux, you should create a cron job. Create a Crontab …
Read More »What is Unique Constraint in SQL Server
What is Unique Constraint in SQL Server? The Unique Constraint guarantees the uniqueness of the colum or column on the table. It can be created …
Read More »Differences Between Primary Key and Unique Constraint
If you are reading this article, you should read my articles “What is Primary Key And Foreign Key” and “What is Unique Constraint” at first. …
Read More »How To Change User Profile in Oracle
We will change user profile in Oracle in this article. Its very easy and simple step. Profiles allow us to manage users according to certain …
Read More »What is Primary Key and Foreign Key
Difference Between Primary Key and Foreign Key You can be find what is Primary Key and Foreign Key and what are differences between Primary Key …
Read More »How To Check Crontab Job Log on Linux
With Crontab Jobs you can run your bash scripts regularly on the linux operating system. In some cases you may want to check if your …
Read More »SQL Server Statistics and Performance Effect
We will talk about SQL Server Statistics in this article. What is Statistics in SQL Server? When you execute a query on SQL Server, it …
Read More »How To Detect and Repair Block Corruption in Oracle
In this article, we will see how to fix block corruption when there is a block corruption on a data file. If Block Corruption is …
Read More »SQL Server Indexes and Performance Effect
This article contains information about SQL Server indexes and performance effetc of indexes. What is Index in SQL Server? Indexes allow us to access data …
Read More »