Subscribe to this blog
The Scary DBA
Archives: May 2010
Buy vs. Build
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build software to do it, but I’m a lazy b_____d so I’d rather just pick up a piece of software that does it for me. I love working for large companies… Read more
0 comments, 438 reads
Posted in The Scary DBA on 28 May 2010
Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work for me, even work I can do just fine on my own, I’m interested. When that software is inexpensive, even better. When it’s free…
I just got word that Confio… Read more
30 comments, 226 reads
Posted in The Scary DBA on 24 May 2010
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT) AS BEGIN IF @TestValue = 1 BEGIN SELECT * FROM Sales.SalesOrderHeader AS soh JOIN Sales.SalesOrderDetail AS sod ON soh.SalesOrderID = sod.SalesOrderID WHERE soh.SalesOrderID = @TestValue END ELSE BEGIN SELECT * FROM Production.Product AS p JOIN Production.ProductDocument…
3 comments, 164 reads
Posted in The Scary DBA on 11 May 2010