Useful tips for everyday
What does it mean when an index is not being used? It means the index tree is being used to go directly to the records…
Is it possible to migrate a character set in Oracle? For database character set migration to be successful, both of these cases require manual intervention…
Is it possible to insert 1000 rows at a time? There may be limitations on the complexity of the query though, so it might not…
How do you join a table? The join is done by the JOIN operator. In the FROM clause, the name of the first table (…
What is the use of query store in SQL Server? The SQL Server Query Store feature provides you with insight on query plan choice and…
How do I start Oracle XE on Linux? Oracle Linux 6: You can start and stop the database using the /etc/init. d/oracle-xe-18c script. You can…
How do I change my location on MariaDB? Changing the default MySQL/MariaDB Data Directory Step 1: Identify Current MySQL Data Directory. Step 2: Copy MySQL…
Why is the server principal not able to access the database? I am trying to access my hosting server’s database through SQL Server Management Studio,…
How do I insert data in always encrypted column? Getting Started with Parameterization for Always Encrypted Right-click anywhere in the Query Editor window. Select Connection…
When to pass XML string to stored procedure? I am passing an xml string to stored procedure in SQL Server for inserting 10000 records to…