Useful tips for everyday
What is service pack for SQL Server? Service packs keep a product current. They include hotfixes and fixes to issues that are reported through the…
How do I check if a table is locked in Sybase? You can view locks in Sybase Central. Select the database in the left pane…
How to configure SQL Server memory? right-click a server and select Properties. Click on Memory . Under Server properties -> Memory enter the value that…
How do you improve function? Here are 12 ways you can help maintain brain function. Get mental stimulation. Get physical exercise. Improve your diet. Improve…
What is select with no lock? The WITH (NOLOCK) table hint is used to override the default transaction isolation level of the table or the…
Does checkpoint affect performance? However, an online transactional workload on a database configured for indirect checkpoints can experience performance degradation. This is because the background…
How do I display a procedure in MySQL? To view the list of the stored procedure, you can query the information_schema. routines table. It contains…
How to fix lock wait timeout exceeded error in MySQL? One of the most popular InnoDB’s errors is InnoDB lock wait timeout exceeded, for example:…
Can I install MongoDB on EC2? Perform these steps on the Amazon EC2 instance that you launched in Launch an Amazon EC2 instance. Go to…
How do I fix Msdtc error? How to fix ‘MSDTC encountered an error’ alert Enable Network DTC Access. Enable a firewall exception for MS DTC.…