Useful tips for everyday
Can a timestamp be a primary key? 1) If values of timestamp are unique you can make it primary key. If not, anyway create index…
What is entity relationship model with diagram? An Entity–relationship model (ER model) describes the structure of a database with the help of a diagram, which…
What is Proc Freq? The PROC FREQ is one of the most frequently used SAS procedures which helps to summarize categorical variable. It calculates count/frequency…
How do I update a single field in MongoDB? MongoDB Update a Specific Fields To update a single field or specific fields just use the…
How do I link my local MongoDB to Robomongo? 10 Answers Download the latest version of Robomongo. I downloaded 0.9 RC6 from here. From the…
Does table partitioning improve query performance? Partitioning is a SQL Server feature often implemented to alleviate challenges related to manageability, maintenance tasks, or locking and…
How do I access OLAP cube? Connect to (import) an OLAP database On the Data tab, select Get Data > From Database > From Analysis…
How can I alter a table without locking it? Adding a column to a table will no longer require table locks except possibly brief exclusive…
What is foreign key violation error? Problem: Trying to use implement a cascading delete trigger and getting a foreign key violation error. Solution: The problem…
How do you normalize a table? First Normal Form (1NF) sets the very basic rules for an organized database as follows: Eliminate duplicate columns from…