Home » Posts tagged "Ed Barow"

Eliminating Temp Table Usage in sp__dbspace

SAP Adaptive Server Enterprise

The sp__dbspace code from Ed Barlow was written 11 years and there are a number of issues that need addressing: Unnecessary use of temporary tables (#tablename) that can lead to lock contention in the system tables tempdb..sysobjects, tempdb..sysindexes, and tempdb..syscolumns. It doesn’t handle the logical...

Continue reading »

Facebook login by WP-FB-AutoConnect