Hi, thanks for the tips. The query itself does not take too long to run - < 1m.

I've decided to 'debug' the DDL by remming out field by field. With...

Hi, this is the DDL (It's actually a sproc):

ALTER PROCEDURE [dbo].[sp_aqr_createTape_RRE] (@snapshot SMALLDATETIME)

AS

BEGIN

DELETE FROM dbo.tb_aqr_RRE_tape_temp WHERE R_SNAPF = @snapshot

DECLARE @count BIGINT

SET @count = (SELECT COUNT(*) FROM dbo.tb_aqr_RRE_tape_temp)

IF...

Biking/running to work would work great in Malta, as travel distances are so small. I could walk it in 25mins from home to work.

Unfortunately, we don't have showers are...

I used to play competitive football (soccer for you US residents) until I ruptured my ACL. Waterpolo also used to be a big part of my life, but long working...