Cache Management Issue

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. :cry:

plague May 03, 2008 12:31

Comments

2 comments

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

MikeyC May 05, 2008 17:59

0
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

Eddie D May 06, 2008 08:46

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Cache Management Issue

Comments

Add comment