If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …
Read More »Service Broker In SQL Server
Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …
Read More »RMAN : ORA-01008: not all variables bound
Error: When trying to connect with rman “ORA-01008: not all variables bound” error is occured. Reason: Bug 10306699 Solution: You need to set the cursor_sharing …
Read More »How To See Partition Details In Partitioned Table On SQL Server
I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …
Read More »Slow queries on MongoDB
During a typical revision of mongod’s logs, we could find slow queries, by default, those queries that take more >100ms. You can change this time …
Read More »Enterprise Manager : java.lang.Exception: Exception in sending Request :: null
Error : When we logged in to EM, there was an error “java.lang.Exception: Exception in sending Request :: null” and the page was not displayed …
Read More »How To Get Script of the Entire Database On SQL Server(Generate Script Method)
We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …
Read More »Primary index concept in Teradata
Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …
Read More »Sybase Questions
1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database …
Read More »PG Log File Maintenance and DB Corruption
It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …
Read More »