Useful tips for everyday
How do I check an existing table? SQL: Check if table exists You can use this table with an IF THEN clause do determine how…
Is key and candidate key same? Primary Key is a unique and non-null key which identify a record uniquely in table. A table can have…
How do you improve the performance of an Access database? The following guidelines can help you optimize the performance of an Access database that is…
How many SQL servers are needed for simple redundancy? I am quite a rookie here and would like to ask all you experts out here…
How to find next running time for schedule job? I often receive a good question on the blog, however, I do not always receive a…
What happens to a SQL Server RDS instance if the databases increase in size and go over allocated space? In most cases, a small increase…
What is SQL High Availability? High Availability (HA) is the solution\process\technology to make the application\database available 24×7 under either planned or un-planned outages. Mainly, there…
Are foreign keys allowed in 3NF? 3NF requires that every non-key attribute of a relation is non-transitively dependent on every candidate key. So if the…
How do you show 2 decimal places in Excel without rounding? To get rid of some decimal places without and rounding, use TRUNC(), which is…
What is a duplicate URL? Duplicate content is content that appears on the Internet in more than one place. That “one place” is defined as…