Tag Archives: SQL Server

Concatenating Row Values in T-SQL

Assuming you have a table like and you want to print out a row containing all the players and games for a given gameId like Then you can use query

Posted in Database | Tagged , , , , | Leave a comment

Use SpringBoot to Deploy ActiveMQ Broker to Tomcat-2/3

This post is to continue the first part of the same topic. It mainly covers: Use commercial database as the data store Use the embedded Tomcat to manage the data source connection pool Background Despite the fact that the ActiveMQ … Continue reading

Posted in Java | Tagged , , , , | 1 Comment

Trace Deadlocks with SQL Server Profiler

Deadlocks can happen at anytime and processes compete for locks, threads, memory or other shareable resources. SQL server periodically detected deadlocks and kill one of the blocking one as victim. In many cases, we want to know the processes involved … Continue reading

Posted in Database, Tool and Debug | Tagged , , | Leave a comment