I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice.
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?
Let’s talk about what XLOCK is supposed to do. XLOCK is a table hint that can be applied to a query to place an exclusive lock on the resources that the query accesses. This can be very dangerous because an exclusive lock on a table or partition could cause significant performance concerns.