Useful tips for everyday
What is high index fragmentation? SQL Server index fragmentation is a common source of database performance degradation. Fragmentation occurs when there is a lot of…
How to create trigger in MySQL? How can we create and use a MySQL trigger? Trigger_name is the name of the trigger which must be…
How can I reduce the.mdf file size now? I checked the database properties and noticed that the initial size of the .mdf is given as…
What is a cluster in docker? A docker swarm is comprised of a group of physical or virtual machines operating in a cluster. When a…
How do I find the first non zero number in Excel? The inner Index function evaluates the values in the A1:A5 range to either TRUE…
Can you have a sum in a case statement? A CASE WHEN expression is often used with a SUM() function in more complex reports, which…
How to grant read only access to MySQL? At the mysql prompt, do one of the following steps: To give the user access to the…
Why is my log file not replicating properly? No is it not replicating properly to one or more subscribers. Replication must happen in order it…
Is there a way to restore transaction log? Right-click the database, point to Tasks, point to Restore, and then click Transaction Log, which opens the…
Is Azure SQL and MySQL same? The difference between Azure Database for MySQL and Azure SQL Database is as follows: Azure Database for MySQL is…