Monthly Archives: August 2016

I’m doing the best I can – is it so bad to say?

I ran into this blog post today: Which is discussing the implications of saying “I’m doing the best I can”. And, suddenly, I don’t agree with the seemingly obvious. Why? Well, apparently one can use that kind of language to justify their lack of actions. On the other hand, we have natural limits, yet those… Read More »

DB Scripts – for my own reference

List of running processes use master Select * from master.dbo.sysprocesses where dbid = db_id(‘DBNAME’) Killing all processes Use master Go Declare @dbname sysname Set @dbname = ‘DBNAME’ Declare @spid int Select @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) While @spid Is Not Null Begin Execute (‘Kill ‘ + @spid) Select @spid = min(spid)… Read More »