Skip to content
Advertisement

Help finding old SQL tool that rewrote queries [closed]

There was this old sql server tool called Lectoneth or something like that, you’d put sql queries in it, and it would rewrite it for you.

I think quest bought them out, but I can’t find where to download a free copy of that software.

Really helps when you have no dba, and have lots of sql queries to rewrite.

Thanks

Craig

Advertisement

Answer

Doesn’t ring a bell, and presumably you’ve seen, but nothing obvious on Quest’s website

Perhaps a tool like Red Gate’s SQL Prompt would help – the Pro edition does SQL reformatting.

Edit
Think i’ve found what you’re looking for, mentioned here – LECCO SQL Expert. The link to the Lecco website does indeed direct to quest, but a 404.

LECCO SQL Expert is the only complete SQL performance tuning and optimization solution offering problematic SQL detection and automatic SQL rewrite. With its built-in Artificial Intelligence (AI) based Feedback Searching Engine, LECCO SQL Expert reduces the effort required to optimize SQL and makes even the most junior programmer an expert.

Developers use LECCO SQL Expert to optimize SQL during application development. DBAs eliminate problematic SQL before users experience application performance problems by using LECCO SQL Expert in production systems.

Looks like it’s no longer about – all mentions of I could find indicated it supported up to SQL 2000, and stale links – looks like it wasn’t a free tool. As said in my comments, I think this kind of thing is a skill well worth possessing and would benefit in the long run to not relay on a tool to try and do it for you.

I wasn’t aware of this tool before now, so I have picked up something from this question – got me intrigued!

Final Update:
To confirm, that product has indeed gone as Lecco was acquired some years ago now. Thanks to Brent Ozar for confirmation.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement