**second year**of T-SQL Tuesdays! Adam Machanic started the whole concept back in November 2009 with T-SQL Tuesday #001, and here we are already up to #024.

So, without further ado…

You are hereby invited to this month’s T-SQL Tuesday #024, which will take place on November 8, 2011.

So, all you T-SQL Bloggers out there, please join the blog party and write up something revolving around this month’s topic:

**Prox ‘n’ Funx**(which is just a coo-ul way of referring to Procedures and Functions).

This topic covers a lot of ground, so there’s a myriad of possibilities in what you can write about. You could discuss a really cool stored procedure or function that you wrote. You could write about a Dynamic Management Function that you can’t live without… or perhaps write about some of the new functions that are coming in SQL2012. How about limitations or “gotchas” or performance issues in working with procedures and functions? And on and on and on…

Now for those nasty rules:

1) Your post must go live between 00:00:00 GMT on Tuesday November 8 and 00:00:00 GMT on Wednesday November 9. If you’re unsure exactly when that is, well, guess what? There’s a function for that! It’s called GETUTCDATE().

2) Your post must link back to this post, and the link must be anchored from the logo (found above) which must also appear at the top of your post.

3) Make sure you leave a comment or a trackback here on this blog regarding your post (so that I can collect the posts and write a round-up).

Optionally:

4) “T-SQL Tuesday #024” should be included in the title of the post.

5) Tweet about your post using the hash tag #TSQL2sDay.

(I have to admit… that last rule is kind of amusing since I don’t have a Twitter account myself… A big thank-you to Rob Farley for initially tweeting this invitation).

I’m looking forward to reading your submissions. But don’t delay in composing your post! T-SQL Tuesday 24 is coming fast! I can almost hear the clock ticking down… Ka-chink! Ka-chunk! Ka-chink! Ka-chunk!

Great topic! Can't wait!

ReplyDeleteReally good tips! Thanks so much.

DeleteHere's mine:

ReplyDeletehttp://sqlblog.com/blogs/rob_farley/archive/2011/11/08/when-is-a-sql-function-not-a-function.aspx

Thanks for hosting, Brad.

Here's mine, thanks Brad!

ReplyDeletehttp://noelmckinney.com/2011/11/t-sql-tuesday-024-stored-procedures/

Here's another

ReplyDeletehttp://datacentricity.net/2011/11/t-sql-tuesday-024-exception-handling-made-simple/

Thanks Brad

This comment has been removed by the author.

ReplyDeleteHere you go Brad,

ReplyDeletehttp://michaeljswart.com/2011/11/t-sql-tuesday-024-procedures-by-the-numbers/

Thanks for hosting! Great topic!

Thanks Brad.

ReplyDeleteConverted a TSQL function to CLR and it coincided with this months topic so....

http://blog.sqlconcepts.co.nz/2011/11/t-sql-tuesday-024-calculating-easter.html

Here's my entry. First time participating, thought I'd compare the differences between Oracle and SQL Server since I have to cross to both sides all day every day:

ReplyDeletehttp://dba-in-exile.blogspot.com/2011/11/t-sql-tuesday-024-prox-n-funx.html

One more! http://sqlblog.com/blogs/merrill_aldrich/archive/2011/11/07/t-sql-tuesday-24-ode-to-composable-code.aspx

ReplyDeleteHere's my entry: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/08/t-sql-tuesday-24-dude-where-s-the-rest-of-my-procedure.aspx

ReplyDeleteWow excellent entries so far. I decided "not" to be innovative and start new series of SQL Server 2012 Analytic Functions - http://wp.me/p2NUQ-44r

ReplyDeleteThanks for hosting Brad!

ReplyDeletehttp://richbrownesq-sqlserver.blogspot.com/2011/11/ssrs-use-stored-procedures-in-datasets.html

Hi Brad, here's my contribution. Thanks for hosting!

ReplyDeletehttp://www.bobpusateri.com/archive/2011/11/t-sql-tuesday-24-functions-v-procedures/

Here's my entry. Thanks for hosting this month!

ReplyDeletehttp://www.airbornegeek.com/2011/11/t-sql-tuesday-24-prox-n-funx/

Hi Brad! Here's another one: T-SQL Tuesday #024: Reporting Services, Stored Procedures, and Multiple Result Sets -

ReplyDeletehttp://blogs.lessthandot.com/index.php/DataMgmt/ssrs/t-sql-tuesday-024-reporting

Hi Brad. Here's one for you. Not my best work, I know... http://thelonedba.wordpress.com/2011/11/08/t-sql-tuesday-024-prox-n-funx-procedures-functions/

ReplyDeleteAh, heck with it. Have another. http://thelonedba.wordpress.com/2011/11/08/t-sql-tuesday-024-prox-funx-maintenance-release-tip/

ReplyDeleteMy pingback looks to not have posted at this moment. Here it is just in case:

ReplyDeletehttp://jasonbrimhall.info/2011/11/08/t-sql-tuesday-024-prox-%E2%80%98n%E2%80%99-funx/

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs: http://www.sqlsoldier.com/wp/sqlserver/usingsystemrestrictschemafunctioninmdxtoquerydmvs

ReplyDeleteBrad,

ReplyDeleteDidn't see my pingback, so here it is:

http://nancyhidywilson.wordpress.com/2011/11/08/tsql2sday-024-prox-n-funx/

Thanks for hosting!

Nancy Hidy Wilson

Better late than never! Thanks for hosting, Brad. http://davidbrycehoward.com/archive/2011/11/fixing-the-query-plan-for-a-stored-procedure-t-sql-tuesday-24/

ReplyDeleteThank you everyone for all the submissions. I'll put together a roundup in the next few days.

ReplyDelete--Brad

Nice post very helpful

ReplyDeletedbakings

This comment has been removed by a blog administrator.

ReplyDeleteThis comment has been removed by a blog administrator.

ReplyDeleteThis comment has been removed by a blog administrator.

ReplyDeleteThanks for providing this informative information you may also refer.

ReplyDeletehttp://www.s4techno.com/blog/2016/07/27/introduction-to-sql/