A Primer on INFORMATION_SCHEMA Views in SQL Server 2000 - Summary

(Page 5 of 5 )

From all the above sections of this article, we could conclude something like the following:

• INFORMATION_SCHEMA views are easy to understand and remember. Use INFORMATION_SCHEMA views wherever possible and applicable.
  
  
• Use system stored procedures if and only if you cannot get an alternative from INFORMATION_SCHEMA views.
  
  
• Using system stored procedures heavily in your application may cause versioning problems, when SQL Server gets upgraded to a newer version.
  
  
• You are always safe (at least better than using system stored procedures) using INFORMATION_SCHEMA views, even after an upgrade to a newer version.
  
  
• Try to create your own schema of views, for your own queries, which are very frequently being used on existing INFORMATION_SCHEMA views.

I also advise you to know and learn about the internal system table and system stored procedure hierarchy, to give you a solid understanding of database activities. Even though it is not so easy to remember all of those issues, at least the concept would help us to derive our own powerful, administrational and consolidated queries, which might be used very frequently. Generally, almost any SQL Server DBA would certainly know about almost all of the internal structures and hierarchies needed to make and keep the database stable in performance.

I would certainly be happy to receive your comments (or feedback) on this article at jag_chat@yahoo.com.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: A primer on INFORMATION_SCHEMA views in SQL Server 2000

>>> Be the FIRST to comment on this article!