Before reading this article, I suggest you read my article “Identitiy Insert On SQL Server” to see what the identitiy property is in the …
Read More »
Before reading this article, I suggest you read my article “Identitiy Insert On SQL Server” to see what the identitiy property is in the …
Read More »Recently, i used a user-defined variable to store some values, and it showed an unexpected result. I updated rows using ‘where a in (@var)’, but this query …
Read More »When we need to transfer data from SQL Server or transfer data to SQL Server, we can use the import export methods in SQL …
Read More »To understand this article, we need to know the following concepts. Page: It is the most basic unit in SQL Server storage. Each Page …
Read More »Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows. First of …
Read More »The ARBn background process starts the rebalance process automatically when you delete or insert a disk from the ASM disk groups. This process is …
Read More »If your computer is not connected to the domain, you can get this error when you try to connect to a SQL Server in …
Read More »The concept of normalization was created by Edgar F. Codd, the founder of the relational database model. During the design of the tables, we …
Read More »It is useful to check occasionally whether everything is normal in the Oracle ASM instance. To do this, some information should be collected and …
Read More »You may encounter this error when taking a backup to a NFS Mounted disk. You will see the error through SQL Server as follows. Msg …
Read More »