Month: March 2022

Code Performance improvements are a layered approach. I think of it as multiple passes and focii to Statistics. slightly out of date stats on huge tables can greatly affect performance. Index Optimization: Review missing indexes, remove unused indexes. Data Management Views: find what is slow on the whole server, and start digging in. Not just

Hi I am Lowell Izaguirre, and I’ve am a cutting edge Senior Database Administrator for SQL Server. I’ve got the paper pedigree for those who care, two MCSA’s and an MCSE as well, but the key is my experience, deep scripting capabilities, and the tools I use to make myself the fastest, most efficient DBA

Tripped over a great example yesterday, where an application was recently upgraded, and ran out of temp db space for the tables, and not the log. The TLDR was that an inefficient query was sticking 500MB of data into a tempdb table to satisfy a query, and the query was called hundreds of times, with

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!