Useful tips for everyday
How do I show all columns in SQL? Tip Query to get all column names from database table in SQL… SELECT COLUMN_NAME. FROM INFORMATION_SCHEMA. COLUMNS.…
Can an identity column be used as the primary key of a table? In many cases an identity column is used as a primary key;…
How to create a relationship in a tabular model? If you import data from a relational database, by default the model designer chooses the foreign…
How do you get zero downtime deployment blue green when there is a database change? The first try at the blue/green deployment process for this…
Will index improve performance? It must improve the performance of data matching by reducing the time taken to match the query value. Now, let’s understand…
How do I select data from another database in SQL Server? This example illustrates a method to transfer data from one database into a memory-optimized…
How to create ACL list? Procedure If the connection you want to create the ACL for is not open, search for and select the connection.…
How does MongoDB detect replication lag? To check the current length of replication lag: In a mongosh session that is connected to the primary, call…
How do I view a trace file? To open a trace log with Traceview from Android Studio, proceed as follows: Start Android Device Monitor. In…
Which is better trigger or stored procedure? Stored procedures can be invoked explicitly by the user. It’s like a java program , it can take…