Useful tips for everyday
What is the meaning of select COUNT 1? COUNT(1) is basically just counting a constant value 1 column for each row. As other users here…
What is transaction recovery? Transaction Recovery is an application recovery whereby the effects of specific transactions during a specified timeframe are removed from the database.…
How do I mirror two SQL Server databases? Right click on the database and select Tasks option. Click on Mirror option. Database Properties dialog box…
What is a full-text catalog? A full-text catalog is a logical container for a group of full-text indexes. You have to create a full-text catalog…
How to find the difference between two dates? As shown clearly in the result, because 2016 is the leap year, the difference in days between…
What does SP _ who, WHO2 and whoisactive do? Sp_whatnow? sp_who, sp_who2 and sp_whoisactive are stored procedures that allow you to view current users, sessions,…
How do I retrieve information from a table? Retrieval with SQL The SELECT clause allows us to specify a comma-separated list of attribute names corresponding…
What is big data storage? Big data storage is a compute-and-storage architecture that collects and manages large data sets and enables real-time data analytics. Although…
When to use group by statement in MySQL? The GROUP BY statement groups rows that have the same values into summary rows, like “find the…
Are log files larger? If you have a huge modification going on, then yes, it can be normal to have a log file larger than…