Comments
Sort by recent activity
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case difference. Perhaps SQL Prompt already ignores case? Maybe someone can confirm this. (You know it'd be super cool if the underscore could be removed during the comparison...) / comments
I apologize, I just realized the JOIN I was trying to do actually contained an underscore (_) in the field on one table, but did not contain it on the other table. This, in addition to a case diffe...
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've ever used: Windows XP, Windows Vista, Windows Server 2003, Windows Server 2008; in a variety of configurations, networks, and environments. I don't know what you mean by "size" of the database. The physical size ranges from 1-30 GB, while the schema could be considered "large" by some. / comments
It smoothly progresses to 100% for the first database, then jumps down to 50% and smoothly progresses from there back to 100% for the second database. I see this behavior on every computer I've eve...
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and see if anything doesn't work as expected.
I also experience the same frustration as jerryhung above regarding Toolbelt updates. The online Upgrade Center stopped working for me months ago, so I either have to email support (and wait a few days to hear back), or download a Toolbelt trial and get the contact from your sales department. That online Upgrade Center needs to get working again. / comments
Thanks for the clarification -- I assumed your software would need to be tested on RTM, regardless of how it worked on RC0. I will go ahead and install the current versions of your products, and se...
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks! / comments
Tanya,
Yes, I've refreshed the cache several times. It is consistent -- I never get hints for TRUNCATE TABLE. My version of SQL Prompt is in the subject of this thread. Thanks!
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons? / comments
I can keep databases that are running on 2005 in production at compatibility level 90. Would that help to ensure a higher success rate of comparisons?
I recently used Dependency Tracker for the first time, and my primary issue with it was similar to this thread. Let me describe my situation and what I was looking for; perhaps this will help focus the discussion.
When I need to do a dependency analysis, it involves not just the database but also other source code in various projects. This requires me to do multiple analyses in various manners and merge them into a central dependency tree. I create this tree as an Excel spreadsheet, which I then pass to my team to work on.
Dependency Tracker would be the ideal tool to perform the database portion of this analysis. The issue I ran into, however, is that there is no easy way to get the list of dependent objects out into Excel. Once I've brought up a diagram in Tracker, I just need the Type and Name of every dependent object. Preferably, I'd like to be able to just copy this list into the clipboard, and have it tab-delimited so it will paste into Excel as two columns. If not that, then I at least need a plain-text export. Again: I just need the list of dependent objects, not what their relationship is, or any other metadata beyond the type of object.
Tracker is not very useful to me until this kind of thing can be done easily. As it was, I had to manually retype the name of every object into my spreadsheet. Not the ideal situation.
The final piece to this would be creating an easy way to select just the objects that are dependents, and not select the original objects that I placed in the diagram for analysis. I already know what those objects are -- I don't need them any more.
Hope it helps! Thanks for another great tool. / comments
I recently used Dependency Tracker for the first time, and my primary issue with it was similar to this thread. Let me describe my situation and what I was looking for; perhaps this will help focus...
I've noticed this problem for a long time as well. It would be nice to get NULL into the list of candidates. To expand upon the above post, NULL seems to never appear in the list, no matter what situation. In particular, I generally use something like this:
...
WHERE
[Field] IS NULL
And NULL is not in the candidate list. However, it does get capitalized automatically if I choose to press Space, which is NOT a completion key for me. So Prompt is recognizing it as a reserved keyword, just not as a potential candidate. This is a usability problem because if I choose to use a completion key, it will insert NULLIF() or some other (invalid) candidate. Thanks. / comments
I've noticed this problem for a long time as well. It would be nice to get NULL into the list of candidates. To expand upon the above post, NULL seems to never appear in the list, no matter what si...
Yes, Compare will compare all types of views (schemabinding or no), along with any indexes. Compare should compare every database object. Good luck with your evaluation! / comments
Yes, Compare will compare all types of views (schemabinding or no), along with any indexes. Compare should compare every database object. Good luck with your evaluation!
Tanya,
Don't you love regression issues?
A link to 3.8 would be great. I'm not using SQL 2008 yet. Could you ask the developers to put a note in the changelog for their next release to specifically mention if this issue was fixed? That way I don't upgrade again and break everything. Thanks! / comments
Tanya,
Don't you love regression issues?
A link to 3.8 would be great. I'm not using SQL 2008 yet. Could you ask the developers to put a note in the changelog for their next release to specifically...
Oops! Sorry for the false alarm. It seems that object hints are indeed working. I was hovering over a TRUNCATE TABLE statement and wasn't getting any hints. I didn't realize I wasn't supposed to get any hints there. / comments
Oops! Sorry for the false alarm. It seems that object hints are indeed working. I was hovering over a TRUNCATE TABLE statement and wasn't getting any hints. I didn't realize I wasn't supposed to ge...