Useful tips for everyday
Which is better SHA or MD5? Both MD5 stands for Message Digest and SHA1 stands for Secure Hash Algorithm square measure the hashing algorithms wherever…
How do I apply a patch in SQL Server 2014? How to Patch a Standalone SQL Server Instance Uninstall the patch(es) previously installed. Restore the…
Who is sysadmin SQL Server? The “sysadmin” fixed server role is designed to provide accounts assigned to the role full control over all aspects of…
How do I pivot a row in SQL? In SQL Server you can use the PIVOT function to transform the data from rows to columns:…
Can we use ORDER BY with aggregate function? An aggregate function cannot be used directly in: an ORDER BY clause. Attempting to do so generates…
How is a foreign key composed in MariaDB? It is composed by a column (or a set of columns) in a table called the child…
What causes the error ” relation does not exist ” in SQL? The error can be caused by access restrictions. Solution: I was using pgAdmin…
How does SQL caching work? In SQL Server, the buffer cache is the memory that allows you to query frequently accessed data quickly. When data…
What is a race condition in SQL? A race condition occurs when two threads access a shared variable at the same time. Then the first…
How convert Nvarchar value to datatype int in SQL Server? “CONVERT” considers the column name, not the string that has the column name; your current…