Useful tips for everyday
How can we prevent recursive triggers in SQL Server? Only direct recursion is prevented when the server trigger recursion option is set to 0 (OFF).…
How can I tell if a table is locked in SQL Server 2012? Expand server – management-currentActivity-expand Locks/object you can see locks by object information.…
How do I insert a row after a specific row in MySQL? INSERT INTO table_name(column_1,column_2,column_3) VALUES (value_1,value_2,value_3); In the INSERT INTO query, you should specify…
How to make left join with row having Max date? SELECT p.id, b.amount FROM Person p LEFT JOIN (select * from Bill where date =…
How to configure a Galera Cluster with MariaDB? The “Galera Provider Configuration” section configures the MariaDB components that provide a WriteSet replication API. This means…
How do you change trace permissions in SQL Server? Select your server name and come down to the section “Permissions for SERVERNAME” to check the…
How do I group ranges in a Pivot Table? Group data In the PivotTable, right-click a value and select Group. In the Grouping box, select…
What does it mean if a function is deterministic? Deterministic functions always return the same result any time they are called with a specific set…
How do I find null columns in a table? How to Test for NULL Values? SELECT column_names. FROM table_name. WHERE column_name IS NULL; SELECT column_names.…
What can we do to boost up complex data queries? 10 Ways to Improve SQL Query Performance Improve SQL Query Performance. Avoid Multiple Joins in…