How to fix Oracle SQL Developer IDE typing is super slow

I’ve been working with Oracle’s SQL Developer for years through its various versions. This tool has become better over the years and improvements can be noticed from version to version. None the less there is one bug that returns every now and then, and it doesn’t seem to be version specific. This is the super slow editing or typing in the IDE SQL code windows, this in fact, in some cases prevent and interfering with our work. How to solve this irritating issue?

(more…)

Make optimization to SQL query with SQL Server Management Studio

Writing SQL queries can be considered by some as a form of art: everyone has a different style of writing and improving them (I’m talking about complex queries). Queries can achieve the same goal while being written in various and sometimes completely different way. While improving and optimizing a query should first and foremost include making sure that everything is written correctly and there are no logical errors, I wanted to share a tool, that some of you might not know, which can help make queries more efficient in times where you’re just not sure how to improve it further.

(more…)