Useful tips for everyday
Which data type creates a variable that can store entire row of a table? %ROWTYPE attribute The %ROWTYPE attribute provides a record type that represents…
How can change PRIMARY KEY to auto increment in SQL Server? If you’re looking to add auto increment to an existing table by changing an…
What is logical connection in data communication? A logical network is one that appears to the user as a single, separate entity although it might…
How many queries can MySQL handle per second? MySQL :: Wikipedia’s MySQL databases handle over 25,000 SQL queries per second. How do you calculate query…
How do I import a database into SQL Server Management Studio 2012? Start the SQL Server Import and Export Wizard from SQL Server Management Studio…
How do I create a schema in NoSQL? Schema design for NoSQL usually involves designing Keys, Indexes & Denormalization of attributes, all of which are…
What is the FOREIGN KEY constraint in PostgreSQL? ERROR: insert or update on table “Table3” violates foreign key constraint “Table3_DataID_fkey” DETAIL: Key (DataID)= (27856) is…
How do you know if something is in 3NF? A relation is in third normal form, if there is no transitive dependency for non-prime attributes…
How to reset identity seed after deleting Records? Although most answers are suggesting RESEED to 0, many times we need to just reseed to next…
What is data staging and ETL? A staging area, or landing zone, is an intermediate storage area used for data processing during the extract, transform…