Useful tips for everyday
Can You migrate Sybase data to SQL Server? After you have successfully loaded the Sybase Adaptive Server Enterprise (ASE) database objects into SQL Server or…
How do you remove duplicate records in CTE? This query will delete all the duplicates from the table. With CTE as. ( Select Id,city,[state],row_number() over…
How do I find mysql schema information? Using the Information Schema SELECT TABLE_NAME FROM INFORMATION_SCHEMA. TABLES. SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA. COLUMNS. SELECT COLUMN_NAME FROM…
Which method will be preferred for data partitioning of a data warehouse? Most large tables in a data warehouse should use range partitioning. Composite partitioning…
WHERE exists and WHERE not exists in SQL? Use EXISTS to identify the existence of a relationship without regard for the quantity. For example, EXISTS…
Should address be in its own table? Keep city, state and postal code in their own fields, by all means, but don’t keep them in…
Can an entity be connected to another entity? In a many-many relationship, an entity of either set can be connected to many entities of the…
How do I access PostgreSQL GUI? PostgreSQL GUI – pgAdmin – Query Tool Once you get started with PostgreSQL tool, this is the most used,…
How do you check index is created or not MySQL? Basically you can pull in the result of SHOW INDEX FROM ‘mytable’ into PHP and…
What is AWS IOPS? IOPS. IOPS are a unit of measure representing input/output operations per second. The operations are measured in KiB, and the underlying…