I’ve been running a lot of huge queries lately and I’m always left wondering how much longer they will run. Here is a nice little query to view the estimated completion time of a SPID. It isn’t always completely accurate, but it gives you something to stare at while the job is running. SELECT GETDATE() read more »

I ran into a problem the other day… I need to remove a bunch of sequential files from my SQL 2008 instance. Here is a script that you can set to increment through files. It will empty the file and then remove it. DECLARE @filename VARCHAR(50) DECLARE @filebeg VARCHAR(50) Declare @FullStatement nvarchar(255) Declare @parameters nvarchar(255) read more »