Useful tips for everyday
How do you store audit logs? Data Store Options Overview. Configure the Policy Store Database. Configure the Key Store and Audit Log to Use the…
Which is used to enable the query cache? To set the size of the query cache, set the query_cache_size system variable. Setting it to 0…
How to pause Database Mirroring in SQL Server? To pause database mirroring Connect to the Database Engine for either partner. From the Standard bar, click…
Can column be aliased in SQL? Column aliases can be used in the SELECT list of a SQL query in PostgreSQL. Like all objects, aliases…
What is the use of CASE statement in SQL? The case statement in SQL returns a value on a specified condition. We can use a…
How do I make a column not unique in SQL Server? Go to the table in context, where you want to make the modification. Click…
What data type is location in SQL? The SQL Server geography data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. SQL…
Is there a way to compare two tables? So no matter how many column are they, no matter what data type are they, as long…
How do I find a non-ascii character? Notepad++ tip – Find out the non-ascii characters Ctrl-F ( View -> Find ) put [^-]+ in search…
How do I TRANSLATE in SQL? Definition and Usage The TRANSLATE() function returns the string from the first argument after the characters specified in the…