Activity overview
Latest activity by alphadog
IMO, I think 14-day trials are too restrictive when found on development tools. Lord knows our overworked staff have very little time to spend on trying out tools. Oftentimes, we install and use once (not enough for decision-making) maybe twice before time runs out. I mean, seriously, there is higher priority actual work to do! [image]
Counterpoint: Many consultants do a lot of short-engagement work with trial tools that last 30+ days. They keep re-installing trial software on new systems...
- alphadog / comments
IMO, I think 14-day trials are too restrictive when found on development tools. Lord knows our overworked staff have very little time to spend on trying out tools. Oftentimes, we install and use on...
Be careful here. SQL Digger is a GREP-like tool, a text-string searcher. I can easily do what SQL Digger does within one db with a single query: select distinct
o.type, o.name
from
syscomments c
inner join
sysobjects o on c.id = o.id
where
c.text like '%cms_getVendorInvoiceList %'
order by
o.type, o.name
But, if I test for a slightly difference string, I get different results in SQL Digger. Also, it does not show dependencies in a navigable way. I'm not talking about the diagram, but rather the textual viewers.
RGDT is, I think, different. There's probably an SQL parser under the sheets that does some better dependency walking.
As for performance, I have had issues with diagrams that I run over entire large DBs, but as has been said elsewhere, the tool is not intended for such a scenario. I made the same mistake you did of pulling in all objects to isolate those I needed; instead I should have pulled in one and then pulled in related objects as needed.
OTOH, hopefully they can enhance and squeeze out more speed with version revisions.
- alphadog / comments
Be careful here. SQL Digger is a GREP-like tool, a text-string searcher. I can easily do what SQL Digger does within one db with a single query:select distinct
o.type, o.name
from
syscommen...
The only way I can think of knowing how many object RGDT sees would be maybe an xml query (xpath) on the export. Something like count(//Database/Object), which would be a count of <object>s attached to <database>.
Unfortunately, my XML editor is on the fritz, so I can't verify if this is correct.
- alphadog[/i] / comments
The only way I can think of knowing how many object RGDT sees would be maybe an xml query (xpath) on the export. Something like count(//Database/Object), which would be a count of <object>s attache...
Well, depending on how you did it, grepping on <object> tags could over-inflate the numbers, given that the tag <object> is used as a child of <uses> and of <used by>, which are children of <object> again.
Grepping on <object> in general would actually give, I think, a general count of the number of links or dependencies.
- alphadog / comments
Well, depending on how you did it, grepping on <object> tags could over-inflate the numbers, given that the tag <object> is used as a child of <uses> and of <used by>, which are children of <object...
Bart:
If I open a saved project, the visual diagram window shows "You have no objects in your project", until you "Reapply Layout" with the button at the top of that window, or select a new graph type.
My machine is a Dell Optiplex GX280, P4 540, i915G chipset, 2GB RAM running WinXP SP2, Hyperthreading is off. If you need more, I can get you a full export... / comments
Bart:
If I open a saved project, the visual diagram window shows "You have no objects in your project", until you "Reapply Layout" with the button at the top of that window, or select a new graph t...
Alex:
Here's what I do. First, save your project. Then, close and re-open it. Don't select a diagram type, that way nothing is diplayed graphically. You can navigate dependencies without the redraw slowing things down.
I'd definitely want a "Hide Diagram" option. I guess you could "Select All" and then "Hide" with the buttons above the diagram, but with large databases, "Select All" is very slow. A single button "Hide All", or just being able to close/open both diagram windows would be better.
- alphadog / comments
Alex:
Here's what I do. First, save your project. Then, close and re-open it. Don't select a diagram type, that way nothing is diplayed graphically. You can navigate dependencies without the redraw...
That pricing is good. In my shop, it would pay itself off in about 8-12 hours; a very worthwhile ROI.
- alphadog / comments
That pricing is good. In my shop, it would pay itself off in about 8-12 hours; a very worthwhile ROI.
- alphadog
Yes, it is possible already. But, the result would be visual/graphical, which is great for top-level viewing. Then, let's say I want to then work on changing things correctly. I'd rather have a textual print-out, maybe to check off as I do my work for example.
I hear 1998 was a good year for lead paint. [image]
- alphadog / comments
Yes, it is possible already. But, the result would be visual/graphical, which is great for top-level viewing. Then, let's say I want to then work on changing things correctly. I'd rather have a tex...
Here's another example query I would love to ask the underlying data: which views out of 200+ involve tables A, B and X?
That would allow me to possibly reuse a view rather than end up re-inventing the wheel.
- alphadog
PS: I am available for consultantion for a small fee... [image] / comments
Here's another example query I would love to ask the underlying data: which views out of 200+ involve tables A, B and X?
That would allow me to possibly reuse a view rather than end up re-inventing...
Suggestion: Text Reports
Here's another. I was just using DT to see if anything was dependant on a certain UDF.
How about a quick-and-simple text report that lists all obejcts for which nothing depends on it downstream? We...