Useful tips for everyday
What causes low page Life Expectancy? Again count is decreased when memory allocation is reduced and data is fetched from the tables in the background.…
How do I group by two columns in SQL? Remember this order: SELECT (is used to select data from a database) FROM (clause is used…
What are FIPS 140-2 requirements? FIPS 140-2 validation is mandatory for use in federal government departments that collect, store, transfer, share and disseminate sensitive but…
Is SQL injection possible with stored procedures? SQL injection is possible if the dynamic SQL inside the stored procedure is not handled properly. Which of…
What is INIT in SQL Server backup? INIT: INIT is used to create a new backup set; NOINIT is used for appending the backup to…
How do you normalize to 3NF? You must achieve the second normal form before you can achieve the third normal form (3NF). 0NF: Not Normalized.…
How to split a field into multiple records? I have an MS Access Database which has a Field called Field1 that contains multiple values delimited…
Why does MySQL give out of memory error? When a MySQL based website or application gives out memory error, it shows that MySQL does not…
How do I increase column size in Redshift? In AWS Redshift is now possible to alter ONLY VARCHAR column but under these conditions: You can’t…
What is the use of the always Encrypted capability in SQL Server 2016? Always Encrypted is a new feature in SQL Server 2016, which encrypts…