Using a global (##) temporary SQL table to prevent a stored procedure from running more than once at the same time

Sometimes it is necessary to ensure that a stored procedure that you are about to execute is not already running. This might be necessary if, for example, your stored procedure is writing to a physical table.…

09/04/2016

Format T-SQL code in your blog

Which service is the best?…

30/03/2016

Using T-SQL RAISERROR with NOWAIT to provide information on long running stored procedures

If you are trying to determine how long the various statements in a stored procedure are taking, then you really need to see output in real time (i.e. not wait till the end).…

17/10/2015

TSQL Common Table Expression (CTE) Recursion

Recursion does my head in if I haven’t used it for a while. The following SQL is a typical employee/manager scenario, but I have used meaningful names to try and make it clear what is going on.……

15/10/2015

Blog