The case against INFORMATION_SCHEMA views

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Thu, 03 Nov 2011 15:49:00 GMT Indexed on 2011/11/11 18:14 UTC
Read the original article Hit count: 264

Filed under:

catalog views

|

INFORMATION_SCHEMA

|

metadata

|

system tables

In SQL Server 2000, INFORMATION_SCHEMA was the way I derived all of my metadata information - table names, procedure names, column names and data types, relationships... the list goes on and on. I used the system tables like sysindexes from time to time, but I tried to stay away from them when I could. In SQL Server 2005, this all changed with the introduction of catalog views. For one thing, they're a lot easier to type. sys.tables vs. INFORMATION_SCHEMA.TABLES? Come on; no contest there - even...(read more)

© SQL Blog or respective owner

Related posts about catalog views

A Custom View Engine with Dynamic View Location

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction: One of the nice feature of ASP.NET MVC framework is its pluggability. This means you can completely replace the default view engine(s) with a custom one. One of the reason for using a custom view… >>> More
Looking under the hood of SSRS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
SSRS is a powerful tool, but there is very little available to measure it’s performance or view the SSRS execution log or catalog in detail. Here are a few simple queries that will give you insight to the system that you never had before. ACTIVE REPORTS: Have you ever seen your SQL Server… >>> More
Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
How to make a product catalog in C#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to develop a product catalog (about 4000 products) application, which would be given to clients on CD or DVD. The catalog exists in webpage format using PHP and MySQL. IMPORTANT: the application is given to clients who maight have old PC, old System. For minimal requirements I would put Windows… >>> More
DRUPAL, Views: I cannot change theme from Views settings

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I cannot change the css theme of my Drupal View. This is a screenshots of the settings: http://dl.dropbox.com/u/72686/viewTheme.png I've tried all buttons, I cannot save the new theme (BlueMarine) in the preferences. It is stuck on Zen (which is my front-end theme). thanks >>> More

Related posts about INFORMATION_SCHEMA

SQL Server script commands to check if object exists and drop it

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Over the past couple years I’ve been keeping track of common SQL Server script commands that I use so I don’t have to constantly Google them. Most of them are how to check if a SQL object exists before dropping it. I thought others might find these useful to have them all in one place, so… >>> More
Slow INFORMATION_SCHEMA query

as seen on Server Fault - Search for 'Server Fault'
We have a .NET Windows application that runs the following query on login to get some information about the database: SELECT t.TABLE_NAME, ISNULL(pk_ccu.COLUMN_NAME,'') PK, ISNULL(fk_ccu.COLUMN_NAME,'') FK FROM INFORMATION_SCHEMA.TABLES t LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk_tc ON… >>> More
SQL Server Views - INFORMATION_SCHEMA.VIEW_TABLE_USAGE

as seen on Stack Overflow - Search for 'Stack Overflow'
When i query INFORMATION_SCHEMA.VIEWS it list all views but when i query INFORMATION_SCHEMA.VIEW_TABLE_USAGE it displays only few views. How can i rebuild all the views info in INFORMATION_SCHEMA.VIEW_TABLE_USAGE? >>> More
Why does MySql have 'utf8' for collation on its information_schema but latin1_swedish on all other d

as seen on Server Fault - Search for 'Server Fault'
Using the latest version of MySql. I created a database, it defaulted to Latin1_Swedish, and just noticed that the 'mysql' database also has Latin1_Swedish. Only the information_schema has a collation of utf8_general_ci. Should I be changing my database to utf8? And if so, how? >>> More
T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

as seen on SQL Blog - Search for 'SQL Blog'
This month's T-SQL Tuesday is being hosted by Brad Schulz ( blog ) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against INFORMATION_SCHEMA views - I provided several examples where I feel the INFORMATION_SCHEMA views fall… >>> More