|
||||||
|
Here’s a confession: I consider myself a time management guru. I think about time management and ways to improve efficiency and effectiveness all the time. It drives my wife crazy. It all started when I read The Seven Habits of Highly Effective People about 10 years ago. Then one Saturday when I was single, I had [...] The other day I was talking to a guy who is just starting out his SQL career. He asked what are my favorite web sites for SQL Server are. I mentioned a few, but I got thinking about it and decided to come up with my official list …as of now….tomorrow things will probably change. [...] Since April 9, 2007, I’ve posted 100 times now. I’m a numbers guy, so here’s what it breaks down to… Declare @startdate date Select DATEDIFF(Day, @startdate, getdate())/100.0 11.38 days per post – much smaller number than I thought it would be. In the future, I’d like to get that number down to 2.5 or [...] The catch phrase around the office these days is “Big Trys and small Trans.” This came about as we were review stored procedure changes and I two suggestions. First, that the entire procedure has a try…catch around it and second that the transaction be as small as possible. Big Try We’ve got standards in place [...] Is there anything bacon doesn’t make better? Here’s the info on the seeds I’m currently eating – kind of tastes like McCormick’s BBQ seasoning. A quick, simple and “easy” way to find deadlocks I’ve found is to do the following: Turn on the trace flag 1222 Create Table #ErrorLogTable I’ve got to give a presentation on my role at Medtronic, so here it is: |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||
