T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

Posted by AaronBertrand on SQL Blog See other posts from SQL Blog or by AaronBertrand
Published on Tue, 08 Nov 2011 07:19:00 GMT Indexed on 2011/11/11 18:14 UTC
Read the original article Hit count: 363

Filed under:

catalog views

|

functions

|

INFORMATION_SCHEMA

|

metadata

|

procedures

|

T-SQL Tuesday

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 short of the catalog views, and expressed my belief that you are better off programming consistently against the catalog views all the time, instead of only when the INFORMATION_SCHEMA views fail. Having...(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 functions

helper functions as static functions or procedural functions?

as seen on Stack Overflow - Search for 'Stack Overflow'
i wonder if one should create a helper function in a class as a static function or just have it declared as a procedural function? i tend to think that a static helper function is the right way to go cause then i can see what kind of helper function it is eg. Database::connect(), File::create(). what… >>> More
Static functions vs const functions

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking at a member function int funct(int x) const; And I'm wondering if static int funct(int x); would be better. If a member function doesn't use any of the member variables should it be static. Are there any things that would discourage this? >>> More
Delphi 2010 Wide functions vs. String functions

as seen on Stack Overflow - Search for 'Stack Overflow'
We're currently converting a Delphi 2007 project to Delphi 2010. We were already using Unicode (via WideStrings and TNT Unicode Controls). I was expecting to replace all Wide functions, e.g. WideUpperCase, with their equivalent, e.g. UpperCase, but they do not work the same way. For example, WideUpperCase… >>> More
Doxygen ignoring inherited functions, when class inherits privately but the functions declared publi

as seen on Stack Overflow - Search for 'Stack Overflow'
Sorry for long winded title, this makes a lot more sense with an example. Suppose we have a class A: class A { public: void someFunction(); void someOtherFunction(); }; And another class that privately inherits from A. However, we re-declare one of the inherited functions as… >>> More
Actionscript/Flex - Is it possible to dynamically extend an object, modify functions, add functions

as seen on Stack Overflow - Search for 'Stack Overflow'
I know this question might be frowned upon, but actionscript is a dynamic language similar to javascript and in javascript I can take an object from a library written by someone else and dynamically (at runtime) add/remove/modify functions, properties, prototypes etc. this is kind of like dynamically… >>> More