Useful tips for everyday
Where is my CNF on Ubuntu? Make sure to restart MySQL server after editing my.cnf: /etc/init.d/mysqld restart . – For me (AWS EC2 Ubuntu), my.cnf…
Is the SSRs server being migrated to a new domain? The bad thing that is going to hit us is the current SSRS server is…
Why is WM _ concat reading in a random order? I’m guessing this has something to do with the way WM_CONCAT functions. Even though the…
How does group by work in PostgreSQL? Introduction to PostgreSQL GROUP BY clause The GROUP BY clause divides the rows returned from the SELECT statement…
How do I copy data from one database table to another database in MySQL? create a new table using similar columns as the first one…
What do you mean by MVD multivalued dependency in Rdbms? MVD or multivalued dependency means that for a single value of attribute ‘a’ multiple values…
How do you update bulk records in SQL? BULK updation in sql. update multiple table single statement. write a Update Statement in single Line for……
How do you find the occurrence of a string? Count occurrences of a word in string First, we split the string by spaces in a.…
How do you pass an array of strings to a stored procedure? Steps Pass the array as a string, each array item separated by a…
Why is SQL Server table insert performance worse? Worse performance because of log file growth although the database is in simple recovery mode. These findings…