Identifying Problem SQL

Many DBAs have their own methods and approaches in this area,  but there are some basic sources and methods that I use. I’ll cover at least the basics of SQL  analysis in one or more future posts

Get SQL from Developers

So the optimum situation is that your developers give you the SQL they’re planning to use in custom code (or better yet, they have a dba write it in the first place).… Read the rest

Continue reading »