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…
Month: March 2022
Who is this Lowell guy anyway?
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…
envthis
generates the command to guarantee the code is a specific server
envtestemail
creates html command to generate and send an email
envtemp
temp db usage
envtejas
example snippet
envtb
info about all tables , sizes and row coutns inthe db
envtasks
generates commands need to use the DBAAutomatedReports functionality
envtablespace
table space used in current db
envtablepart
no description at this time.