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 Read More …
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 Read More …
RDS_Aurora_MySQL_Update_Logs Read More …
Querying_Login_Failures_Azure_SQL Read More …
Querying_JSON_in_SQL Read More …
Querying_JSON_in_SQL Read More …
Querying_Facets_in_SQL Read More …
If you have ever worked with SQL Server, and wanted to script a table, you know it is a GUI process, that behind the scenes, is calling SQL Management Objects(SMO) to create the script for you, which you can then Read More …
Querying_Application_Roles Read More …
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 Read More …