Cache Management Issue

plague

I have been encountering issues with SQL Prompt not recognizing the variable I have created or the temp table I have created when I write a query in Query Window in SQL Server 2005. I assume this is due to cache management. But it will be very annoying if I have to run refresh cache everytime I define a variable and delete a table/column. I have used other components for development environment before and I never had to do cache management myself. The applications does it in the background without me knowing they do it. Is there any particular settings I'm missing here to get SQL Prompt to do the same kind of function? :?

Please let me know if this product will have that in the future or whether I'm missing a settings as I worked hard to convince my boss to purchase this product. Now I'm being blamed for a product that is not working completely.

MikeyC

I would check to see how many lines you have SQL Prompt set to look at in your queries. (Under "Listed Candidates" -> "Performance")

It has options for the number of lines to process, and the number of variables to display in the list.

I work with very large queries, and I have had to set the option to have it scan the entire block even though it is slower.

Michael

Eddie D

Hi

Thank you for your post into the forum.

I have found the following knowledge base articles that may be of use to you.

Reducing memory usage to improve SQL Prompt Performance:
http://www.red-gate.com/supportcenter/C ... _usage.htm

I have created a new table but it does not show up as a candidate:
http://www.red-gate.com/supportcenter/C ... 000103.htm

Please reply back if you require further help and assistance.

Many Thanks
Eddie Davis

Eddie Davis
Product Support Engineer
Red Gate Software Ltd
E-Mail: Support@red-gate.com