Did you execute the script within the context of the database you want to analyze? If you run this script against the default database when you open a query...

I am pretty sure I have seen this recently.

This happens quite often. It would be great to be able to go to a web page where the SQL DBA collective could review a list of packaged...

What is the need for web log files, and therefore Flume?

Thanks

Jeff

StLouisMO

Thanks, Gail.

So scan density was basically physical fragmentation? Is this correct?

Again, thank you Lynn.

That is completely in line with what we are seeing. There is no performance problem, and the vendor is going by a guideline that is...

Thanks, Lynn. I am aware of this, but did not want to use that argument when trying to convince the vendor and customer that we are doing our job...

Why not just check the rowcnt value in sys.sysindexes for the OBJECT_ID(tablename)

select max(rows) from sys.sysindexes where id = object_id('<table_name>')

This is an excellent script that I will be keeping close at hand. Thank you for seeing the need for this and taking the time to create the...

Very nice script. As noted in the above post, the last few lines should read:

then windows_server_release_name + rtrim(' ' + windows_service_pack_level) + ' ' + case when left(windows_server_release_name, len(windows_product_type))...

Again, David. Great idea. No joy, however. Eventually granted sysadmin level permissions and connection still fails within datastage. Trace is empty.

Thanks

Jeff

No dice. Unfortunately, the DataStage admin guy's troubleshooting skills amount to Work/Doesn't Work, so I am trying to diagnose this problem without access to the datastage server.

Thanks, it...

Actually, David, I had not considered that at all. Thank you for the suggestion, and we will try it out immediately. Will update when I hear from...

Nice article, but you just made every support call I handle twice as long. Every user that sees this will be adding SQL DBA to their resume and business...

Very nice article about an issue that every SQL DBA will encounter eventually. I have seen this type of problem crop up in 3rd-party solutions that are supposed...