brubinstein

Thanks APC for keeping our equipment running despite a spotty grid (and for the 68000 alerts in my junk mail folder ).

"unnecessary cursors" Ugh. Cursors are almost never necessary. Fundamentally they break good query design practices. 99.9(999)% of the time they are just lazy shortcuts. Way back in the day when the bulk of our code was written, the contractors we brought in used cursors everywhere. Cursors are what happens when developers…

This would be so great. I recently came across duplicate nodes and accidentally deleted the wrong one. Had to restore the database just to get one node's data back.

Good points; I did not know that about Oracle. And it actually makes sense to use a cursor if you ​need to call a stored procedure on every row. In my case though, the SP it called wasn't used by anything else; it basically was an even worse way of doing nested cursors. And all hyperbole aside, it's really the nested…

That table shows history for the Orion database. I don't think you are understanding what I am trying to do. I am monitoring one of our production databases. I got a request for the team that manages that DB for a report of the fragmentation for all indexes in their DB. In SAM, the Top Indexes for Database counter limits…

Well, it's easy enough to do a custom SQL query to get both clustered and non-clustered indexes. The problem is that the number of each is limited by the Top Indexes for Databases counter. I got around that by setting that to 200 but that is such a hack of a solution. It doesn't seem like there is a way to make that "All…

Thanks for the response James. I already have Top XX Clustered/Nonclustered Indexes by Fragmentation charts. The problem is: a) I would like to see all indexes b) SAM doesn't seem to respect the "Number of records to retrieve" setting for the Top Indexes for Database counter for the Top XX Clustered/Nonclustered Indexes by…

Thanks for providing that!

Hey, sorry I didn't respond earlier; I haven't been on Thwack for a long time. If you go to the volume details view for one of the volumes that isn't displaying correctly, what does that show for size, space used, and space available?

Thanks again James, for the replies. To answer my own questions: 1. It's not elegant. At best this is a hack and I don't want to have to keep an eye on the number of indexes of each database and adjust this according. This is also an issue since the DB is handled by another team. I don't have access to it with my account…

I got it working and learned a couple things in the process. First, the problem does appear to be related to InstallAware. Specifically, some packages built with InstallAware will fail when attempting to install as SYSTEM. From the InstallAware forums, I learned that you can use PSEXEC to simulate this and indeed the…