Useful tips for everyday
When to use off-row columns in memory optimized tables? Certain limitations and caveats to using off-row columns in a memory-optimized table are listed below: If…
How do I allow remote connections to MySQL from specific IPs only? To connect through remote IPs, Login as a “root” user and run the…
How to use SELECT clause using in very slow? – Stack Overflow SELECT clause using IN … very slow? Could you guys please review the…
What permissions are needed for DBCC? According to Books Online, DBCC Shrinkfile requires membership in the sysadmin fixed server role or the db_owner fixed database…
How do I create a database script in PostgreSQL? Summary You can create a database using the psql Windows Command Line (SQL Shell) with the…
How do I unzip a file in SQL Server? We can unzip a file using the execute process task. Rename the execute process task as…
Why does oracle query run faster the second time? Another factor that makes the initial query slower is the fact that Oracle has to hard…
Should I use MySQL JSON data type? MySQL supports a native JSON data type defined by RFC 7159 that enables efficient access to data in…
How do I authenticate in MongoDB shell? Starting in MongoDB 4.4, you can either: Omit the password to prompt the user to enter a password:…
How do I update CTE? If your CTE is based on a single table then you can update using CTE, which in turn updates the…