DBA On Demand

Never stop learning and never get comfortable. There is always room for improvement!

Stay out of your comfort zone. The majority of my career I have worked exclusively with SQL Server, and I had very little interest in branching out to other engines. Why would I? SQL Server is the best, hands down. Period. As I had done a few times prior... My time with my current company had run its course and I was moving on to...

Many SQL developers underestimate the power of temp tables to create efficient queries.

Recently I was handed a complex stored procedure comprised of excessive subquery usage and multiple instances of nested case statement. By using temp tables to reduce the datasets that were needed to deliver the desired results, I was able to reduce ex*****on time from ~7 minuted to

Recently we worked with a large corporation who was utilizing a financial application with a SQL Server backend. They had been plagued with financial extract reports taking well over a day to return a months worth of data.

We identified the query being generated by the application and broke it down to identify possible pain points.

We then implemented a single supporting index in addition to the stock indexes created by the application to support there abnormally high transaction load.

The results?

The same report now takes less than 3 minutes to complete.

Issues like this are extremely commonplace in corporations nationwide. Dont accept poor performance as the "norm", let us fix the issue at the source!