May 11 2010
I love seeing good documentation in code. I really love seeing honest documentation in code. Seeing comments that basically show the developer has given up, hacked together a poor workaround to get a tasked accomplished at the cost of performance for every customer… full of Awesome. This is slightly redacted code from a stored procedure [...]
May 10 2010
#11 – Memory Settings Unless you have been working with SQL Server for a while, you may not go into the Server Properties or Facets and tweak much of anything after a successfull install. After all, there are a great deal of things out there and it can be really confusing. Let’s keep it really [...]
Apr 30 2010
#12 SELECT * Plain and simple this is a lazy habit that causes performance problems and possible code fail over the application lifecycle. That is all. “Explain myself” you say? Fine. Imagine you’re given a grocery list by your Significant Other that states: “Go to the Sunny Mart and buy everything. It’s exactly what we [...]
Apr 26 2010
#13 Being A Visible DBA At The Wrong Time I’ve given presentations where I state that one of the qualities of being a good DBA is being a visible one. The days of being a Database Administrator that sits in the smallest cubicle next to the noisy refrigerator and generally avoided by the rest of the [...]
Jan 27 2010
On Twitter this morning I saw a plea for an explanation on what CROSS APPLY is in Transact-SQL. I answered the question via email and then realized that it may make for a post here on The SQL Agent Man… When used, CROSS APPLY will execute the function listed in the CROSS APPLY sub-clause of the [...]
Sep 19 2009
Quest Connect 2009 is rapidly approaching. I’ll be presenting along with Brent Ozar and Tom LaRock on the subject of SQL Administration for the System Engineer.
Jun 23 2009
Need to return information on all indexes for a selected SQL Server database. Here is the code!
May 19 2009
Simple way to determine the last time the SQL Server service was started.
