A very small post this one, covering a little nugget that I’d almost forgot until it came up trumps again this week; TSQL FOR XML PATH can be a nice solution for concatenation of strings across rows (in a given column). It’s fairly common to have the need to concatenate column based data, as the […]
Evening all, I thought this would be worth sharing, in its current form. It’s a small piece of SQL (this would be encapsulated in a Stored Procedure) that allows you to search through a host of objects encompassing Stored Procedures, Functions, Views, Triggers and even Indexes for a specific search term (i.e. an object name). […]
I’m back from my hiatus which encompassed getting married, eating far too much food and drinking wine and beer on the wonderful Adriatic coast. It’s time to get back to some serious coding and perhaps reconsider the longer term plans for this blog. To start us off, I’ve been contemplating pushing a little money into […]
A common task within SQL is to search an objects definition for a particular reference. This might be a table, column, procedure, function or view name. Below are a few techniques for achieving this. I’ve also highlighted some tables that are related to SQL Server Maintenance Plans and how to start searching interrogating the data […]
Depending on the infrastructure of the application you are working on you may find yourself in need of really being able to interpret what’s going on in the guts of SQL Stored Procedures in a fast and efficient manner. For a small Stored Procedure you’re probably going to find that, locally at least, the debugging […]
I’ve been having a little think about what to cover next, keeping in mind that I want to at least attempt to shorten the posts and not drive everyone nuts with insanely lengthy content, etc. I was chatting to one of my colleagues today and we arrived on the topic of debugging SQL Stored Procedures. […]
bearandhammer 